Hello All
I'm fairly new to using excel so apologies if there is a fairly straightforward solution to my problem.
I have a workbook with 2 sheets. I am mimicking data from the 1st sheet to the 2nd sheet using the = formula (e.g.=Sheet1!B12).
On Sheet 2, I am inputting fresh 'raw' data in the same row as the copied data from Sheet 1 as this data is relevant.
The data on Sheet 1 is always changing so I use the A-Z sorting tool to help me organise the data. However, when I do this, the mimicked data on Sheet 2 is the only data that sorts A-Z. The 'raw' data I input on Sheet 2 does not sort with the mimicked data from Sheet 1.
Is there a way of locking the rows on Sheet 2, so that when I A-Z sort the data on Sheet 1, the 'raw' inputted data on Sheet 2 sorts with it.
Many thanks in advance.
Regards
FinnyMac
Bookmarks