I need a macro that when I run it takes data from one file and adds it into the existing sheet I have. Right now I have a an excel workbook (1st picture) that has a lot of parts listed and the sum of the times they were used. On top there are board numbers. I want to take a new file (2nd picture) for example and run a macro to only take the data I need and add it to the existing workbook and adding to the sum. I would also need it to add a new column with the board number.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Adding a new workbook into an existing one
- Thread starter nmh7
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,690
- Office Version
- 365
- Platform
- Windows
Duplicate to: Adding New files to existing worksheet
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
Upvote
0
- Status
