Hi there,
I am having issues sorting columns on a given worksheet. When a column is sorted in one tab, it is jumbling another column on a linked tab. Vlookup formulas are being used throughout the worksheet.
So, for example in the attached file;
Currently the way the file is set up is when a new project comes in, we put initials in the 'Audit Date' column of the 'To Be Audited' tab. That then pulls over to the 'Customer' tab via the 'No Edits-Audit Sheet'.
I want to be able to sort in the 'Customer' Tab the states, city or state A to Z and not have it mess up the 'To Be Audited' tab. Right now, when someone sorts one of the columns, the initials in the 'to be audited' tab jumble, and the initials are no longer with the original project.
Please can someone give me an idea as to why this is happening.
Thanks a lotExample.xlsm
Bookmarks