I have about 25 sheets in an excel file, all have the same layout with different info. The info is to do with stock in a shop. And each sheet is separate to an area of the shop, ie laptop, tv, washing machine etc. So one supplier can have products in more than one area. All sku codes are 7 digits long and the first 3 digits identify the supplier. The last 4 then are product specific.
What I want to do is have a drop down with the supplier's name, then this populates another cell with their 3 digit identity code (I have that part done).
This is where I can't work out what to do. I then need the info referring to that supplier pulled from every sheet and put into the sheet where the drop down box is. There are only 4 columns that are needed. These are A, B, C and D. Ideally I'd like them to move over 1, ie A to B, B to C, C to D and D to E. Then I'd like the name of the source sheet to go into A.
I can provide the file if necessary.
Bookmarks