Hello Everyone,
I am new to VBA and really want to dive into learning this! I am looking into how I would create a macro using VBA to go into 4 closed workbooks and sum the same column (C:C) on the same worksheet (Trial Balance) for each differently named workbook and insert the sum of each column into cells A1, A2, A3, A4 on the current workbook w/ the macro. Can anyone please give guidance on how to accomplish this? Any help is greatly appreciated!
Thanks!
Last edited by Hoover5896; 07-08-2017 at 12:47 AM.
Example
Please Login or Register to view this content.
Hi Jindon, thanks for the quick response! So far I have:
Please Login or Register to view this content.
But the macro when run wants me to locate the file location and select the worksheet for each workbook. So I must be missing a step in changing the string? It also creates a link to the workbook and I want to do zero data links if possible.
Last edited by Hoover5896; 07-08-2017 at 01:38 AM.
If you look into a formula bar and see the formula after running the code.
It should give you correct sheet name in the formula.
Last edited by jindon; 07-08-2017 at 01:28 AM.
I am sorry, I am still really new to this so I am not getting the code right. I ran through the code and the formula bar says this for each of the 4 cells when pulled into the current macro workbook so a data link is being manually created so far, and I have to locate the file and sheet once I run the macro.
Please Login or Register to view this content.
You are missing back slush
Please Login or Register to view this content.
It works now and I added the /2 you mentioned. Perfect! Thank you so much!
You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks