Morning everyone. Just first wanted to say that I have been a long time lurker and have used the site for a while, I dont know what I would do without all the help that has been posted on here. With that said I have a little project that I am working on in order to make things easier on me and my job. Here is the scenario:
We have an equipment sheet that our sales team fills out when quoting customers. The sheet has everything from the items Brand, Model Number, Description of item, cost, MSRP, ect... on it followed with a QTY that is needed. Now one of my jobs is to go through the sheet and create a summary page of everything that is selected and place certain data onto this "Summary Page". This is what I am trying to do:
When a QTY of greater than 1 is selected on the "Equipment" page it will autopopulate the "Summary" page with certain data, mainly the description of the item followed by the QTY ordered. Let me see if I can do an example below
Say I have this equipment list below:
'EQUIPMENT' Sheet
Example.png
Now since a QTY greater than 1 has been placed into column E2:E5 I would like to populate data from the corresponding B, C & D column into the 'Summary' sheet
'Summary' Sheet
1 HD51 I/O, Rugged Dome, HiRes, VF Lens
3 HD73 IR, I/O, Rugged Dome, HiRes, VF Lens
I hope this makes since. If I am able to do this it would save me countless hours of CTRL+V CTRL+C work, that and its hard to catch every value when you have over 3,000 items on a equipment sheet.
Thanks in advance
David
Bookmarks