I have a final report (master document.xlsx) that I need to import several (rawdata.xls) files into. I also would like it to prompt the user as to where to pull the (rawdata.xls) files from. I have been messing with VB, but no luck. Please help???
I HAVE TO DO THIS EVERY DAY MANUALLY.
Thanks,
Preston
We would need some workbooks sample in order to help you.
Are you able to attached your Master Document workbook and one or two Rawdata workbook as samples?
Make sure there are no sensitive data in your file. We are interested in your workbooks layout, what is to be transfered ( all, specific columns or rows, individual cells, etc)
Be as specific as possible. Will the multiple RAWDATA workbooks be in the same folder or the folder is to be selected by the user each time.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Im trying to upload my example but I am having trouble attaching them. Do you have an Email?
You don't add the desired result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Seeing your RAW file, your MASTER document has certainly a different layout. As your RAW file was uploaded right, would you do the same for the MASTER file, please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks