I have the macro below that works perfect. I need to make an adjustment but not sure where or how. Currently the macro separates the data based on a cell value and only transfers certain columns to new sheets. Well I need to check and see if the cell in AN is null, if it is then it should bring over the value found on BG, if it’s not then bring over AN still.
The attachment has how the data should look, what you see highlighted is from the cell in BG because AN was Null.
Please Login or Register to view this content.
Bookmarks