Copy formulas down to last row of report

[aurisab]

Hi,

I get a travel report every month (grey headers) and I need to add columns with department sale and managers name (green headers) right next to the report using a table and copy the formula down to the last row of the report. I have recorded a macro but as you can see it will stop on row 10, how can I make it copy formulas based on the rows of the report and not based where I stoped recording.

Thank you !

Please Login or Register  to view this content.

[flyboy54]

embed a [counta(F:F)] to get the total number of rows from column F
use this to adjust the range you are selecting and use the FillDown function.

[arlu1201]

aurisab,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

[arlu1201]

This is the code you need -

Please Login or Register  to view this content.

[aurisab]

Arlette,


Thanks for your help, I was able to use you code but It will only fill in column F to the last row, and will also do row G2 to H2 and the last row G10 and H10 of the range, yet it will not do anything for in between the range G3 to H9.

[arlu1201]

Which is the column that will have data always? I have considered column A, is it some other column?

[aurisab]

Yes column A will have all data.

[arlu1201]

It will be good if you attach a sample file so that i can check it.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[aurisab]

Find it attached.

[arlu1201]

I changed the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and it worked fine.

[aurisab]

Wonderful, it works ....

Thanks a lot!

[arlu1201]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

I will do it for you this time.