I've been trying like crazy to get this to work. I'm trying to take all the data from column A in multiple workbooks and list them one after another in column A of my transfer workbook. The trouble really comes from from needing to do it with a random amount of workbooks and lengths of column A
This is what I have so far:
Any help would be great.
Please Login or Register to view this content.
oops. I did change the name of transfer.xls to zip it and post. I had to delete a bunch of info due to work security. The orginal is titled correctly.
Hi,Originally Posted by Rlyeh462
instead oftryPlease Login or Register to view this content.hthPlease Login or Register to view this content.
---
Si fractum non sit, noli id reficere.
Thank you very much. It works perfectly now.
One more quick part on this. I need to put the file name in column k but I can't get it to loop right. Each row needs the name in "K" from the file it came from and all I can get it to do is put it in the top most unused row.
Hi,
ifwas where you wrote the line, thenPlease Login or Register to view this content.should put your saved filename into KPlease Login or Register to view this content.
hth
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks