Hi All
I have a spreadsheet which has 32 branch locations in the consolidation sheet and this works fine and consolidates all the data from 2 other sheets, My problem is that I now need a macro which can copy out row by row to each of the branch destination sheets but not remove the data from the consolidation sheet (if that makes any sense?)
So lets say the first branch is called Barking then what I need the macro to do is look at the consolidation sheet identify the coloumn & row with Barking branch in it(Branch Name is always in coloumn "B" and then copy data from Col "C" to Col "I" in what ever row Barking sits?and then continue doing this until all location data has been copied to relevant branch sheet!
All these sheets are in a Workbook called "Data Entry"
Is this possible I ask?
Await anyones help on this
Bookmarks