I have 10 separate files that each have a data input sheet.
I have 1 master file that has all 10 sheets in it and an extra sheet to display all 10 sheets information on 1.
The drama I am having with sorting the master sheet is that every cell in the 10 sheets has a formular to copy what in the corresponding cell within the separate file. So techincally, the cells are not blank.
The cells range is B5:G1004 on every sheet.
I paste 'values only' from the range of each sheet into the master sheet, but when I go to sort column B Ascendingly, it puts all the data at the bottom of the rows and there is 10000 rows on the master sheet. I cant get it to flip around.
What I need is a way to clear the cells on the 10 sheets that do not have a value before I paste into the master sheet.
Can anyone help.
Range B5:G1004 .. need to delete the contents of that range that do not have a value (even though there is a formular in the cell)
Hope someone can help ..