I have a workbook that will always have a different number of worksheets. Each sheet will have a different part number (always in the same cell O100) and a different quantity (always in the same cell E21). I want to create a macro that will create a new sheet and make a column that will compile the part numbers and quantities from each sheet. I honestly, don't even know where to start. i know this is possible. Any help you can give would be appreciated.
Thanks,
Jeremy
Try something like
Please Login or Register to view this content.
Last edited by jindon; 04-24-2012 at 05:17 PM. Reason: Missed "="
Hi Jeremy,
Hopefully this macro does what you're looking for. It creates a new worksheet called Summary and puts the data there from each worksheet's cells O100 and E21. You can put it into a standard module.
Please Login or Register to view this content.
Thank you so much Paul. That worked perfectly.
Last edited by Jerums; 05-01-2012 at 09:45 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks