Henrybukowski
New Member
- Joined
- Apr 16, 2013
- Messages
- 29
Hi all,
This forum has helped me a good many times through the posts of other people, but this time I think I need to post for myself.
I'm generally pretty good at IT and solving my own problems, but Visual Basic is a step beyond me, I feel. This said, the Macro I need to create may very well be straightforward for the guys on this forum.
Here's the situation:
E.g, Say I have 10 workbooks, named Book1, Book2, Book3 etc, which each have a number ranging from 1 - 10 in cell A2. Could A macro be designed to bring all those values together into cell A2 of an 11th workbook, e.g one entitled book11? If so, could somebody assist or advise me in creating one? I'm aware that said Macro may need to exist in each separate workbook in order for the process to be carried out.
I really appreciate the efforts of anyone who can help me - I cannot stress enough how this could change the way we do things at work.
Henry
This forum has helped me a good many times through the posts of other people, but this time I think I need to post for myself.
I'm generally pretty good at IT and solving my own problems, but Visual Basic is a step beyond me, I feel. This said, the Macro I need to create may very well be straightforward for the guys on this forum.
Here's the situation:
- Every month we collect data from a number of employees and average it out in a new excel workbook ready for analysis. Each employee sends in their monthly data, structured identically, with only the numbers in the data tables different.
- At the moment, we just copy and paste every single data return into the separate worksheets of a single workbook, and on the front page of the workbook we create a simple formula which adds the equivalent cell in each sheet together to get a total. Its not hard to do, but its very lengthy as a process.
- What I've been researching, is the possibility of a macro that can automatically send the outputs of separate workbooks into one central workbook, so that we don't need to go through the copy and pasting of each return every month.
E.g, Say I have 10 workbooks, named Book1, Book2, Book3 etc, which each have a number ranging from 1 - 10 in cell A2. Could A macro be designed to bring all those values together into cell A2 of an 11th workbook, e.g one entitled book11? If so, could somebody assist or advise me in creating one? I'm aware that said Macro may need to exist in each separate workbook in order for the process to be carried out.
I really appreciate the efforts of anyone who can help me - I cannot stress enough how this could change the way we do things at work.
Henry