Eville
02-18-2009, 05:52 AM
Hello,
My 1st idea was to collect data from the logsheet into the last sheet called Blue residue. But thats not gonna work (as you can see) because there is no fixed amount of logsheets. It can be 2 or 30 or more.
Im not sure how im going to manage this but now my idea is to get data from another file and import it into this blue residue sheet.
Then i want to copy each data (coil, supplier etc) into the logsheets.
Im not sure because im not skilled enough to do so but maybe it is possible to do it with the Vlookup formula (i failed to do so as you can see in logsheet(1) ) combined with something that checks the last coil position? Maybe a formula i can use in conditional formatting that checks last coil data and fills in the other data in the rows below for each logsheet? So i enter the 1st coil and the formulae do the rest of the work?
When you open the attachement please ignore the auto update Query refresh. Im still messing about with that trying to import the data the way i can use it ...
Thx in advance!
Eville :hi:
My 1st idea was to collect data from the logsheet into the last sheet called Blue residue. But thats not gonna work (as you can see) because there is no fixed amount of logsheets. It can be 2 or 30 or more.
Im not sure how im going to manage this but now my idea is to get data from another file and import it into this blue residue sheet.
Then i want to copy each data (coil, supplier etc) into the logsheets.
Im not sure because im not skilled enough to do so but maybe it is possible to do it with the Vlookup formula (i failed to do so as you can see in logsheet(1) ) combined with something that checks the last coil position? Maybe a formula i can use in conditional formatting that checks last coil data and fills in the other data in the rows below for each logsheet? So i enter the 1st coil and the formulae do the rest of the work?
When you open the attachement please ignore the auto update Query refresh. Im still messing about with that trying to import the data the way i can use it ...
Thx in advance!
Eville :hi: