Insert rows and copy data from other sheets

[Popa]

Hey all -

I have a project that is currently beyond my skill level and will appreciate any assistance in pointing me in the right direction. I believe I am looking for a macro, but am not sure if there is a better solution.

Background - In the attached workbook there are 11 worksheets (1 Summary, 9 Areas, and 1 Input). Each month, I will be emailed the 9 Area worksheets and copy them into the file. Each Area worksheet has an account description in column A, variance in column F and place holders in columns I to T for an explanation and its associate $ amount.

My wishful thinking -Columns B through G on the Summary tab will automatically update. However, I would like to find a macro which will insert rows below the account descriptions in column A on the Summary tab and list the corresponding Area name, $ amount and explanations provided in the 9 Area worksheets on the Summary tab in columns H, I, J. (There is an example on the attached Summary tab cells H10 to J17 of what I am trying to explain).

I know it's a bit involved and will appreciate any assistance.

Popa

[rylo]

Hi

Here's a start. It is build for your example file. It will basically recreate the summary sheet and hopefully insert all the necessary rows and bring back the results.

You will have to put in the values into summary B5 and D5. Once you put in these values, the formula in A3 will update. Let me know if there are any problems.

Please Login or Register  to view this content.

rylo

[Popa]

Rylo:

Sorry for my slow response in thanking you. The code below works great and is exactly what I was looking for. I'm both appreciative and amazed at how quickly you pumped it out! If you do not mind, could you refer me to a book or class that would help a VBA noob increase their understanding and skill in writing macro's?

Thank you again,
Popa

[rylo]

Popa

That questioin is asked a lot. Do a search on this site, and you will come up with some views / suggestions. One of the greatest resources is sites such as these. Review the questions and answers, and examine the code to see how it works to solve the problem.

rylo