I have multiple workbooks that i need to extract column C, starting at C7,
I want to copy that data into a new workbook.
I would like to select the multiple workbooks, and then have that data combined into a new workbook.
Column C, starting at C7, had various amounts of data
Are the workbooks all in the same folder? Do they all have a sheet named "Clothing"?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Yes the workbooks are in the same folder, but the names of each workbook varies.
I don't care about the book names but does each one have a "Clothing" sheet?
BTW: I hope you realize that your project is password protected.
Yes each one has a clothing sheet. (sorry, i misunderstood what you were asking) Yes it is a walmart sheet, so i cant unlock it, i just wanted to move the SKU column to a new workbook.
Be careful with this one - if it works, see whether it's what you wanted. The program is in the attached book but you need to have one of the source books active not this one unless it's in the same folder or you could supply the actual path in the code.
Please Login or Register to view this content.
Thanks for the file, I will test it out
This runs a little smoother:
Please Login or Register to view this content.
Last edited by xladept; 04-21-2020 at 05:58 PM. Reason: Details
( removed )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks