Dragging down formulas in one sheet according to the number of lines in a different sheet

[isabelle.r]

Hi guys,

I tried to be as descriptive as possible in the title, but it's probably not clear, so here goes.

I have an Excel file which uses data pasted from a different Excel report.

The report contains lots of unnecessary columns, and is horribly formatted, so I first have the report data pasted to my Excel in sheet "Paste Here", and then I have a second sheet "Summary" which pulls only the relevant data from the "Paste Here" sheet, and adds a number of calculations and lookups, etc.

I have all the necessary formulas ready on line 2 of the "Summary" sheet, from col. A to col. R. Now all I need is VBS to select line 2 from A to R, then drag down for the same amount of lines as there are in "Paste Here" (the length of the source report is variable each week).

So for ex. if "Paste Here" has 97 lines, I'd need line A2->R2 in "Summary" to be dragged to line 97.

I'm sure this is simple, but I'm having trouble finding what I need, so I'd appreciate any help.

[JohnTopley]

Attach a sample workbook not image!)

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[isabelle.r]

Norie,

That's what I was looking for. Thank you