Aligning formulas on rows with imported values

[JungleJme]

Hi everyone,

I'm a VBA beginner and am just starting to write some basic macros. I am currently writing a macro to update a spreadsheet with data from another source.

I've got the code to open up the other workbook and copy the new data in. However, i then need it to do something a bit more complicated.

The new data goes in columns A:S. However, columns T:AF hold formulas that are driven by the source data.

I need something in the code that will find the last entry in column A (for argument's sake) and Copy down the formulas from columns T:AF so the data is aligned.

I had considered just copying the formulas down to a row that the source data would never reach, but as this is a learning exercise i would like to do it the hard way!

Thanks in advance for anybody's help.
J

[JungleJme]

Not sure if this works on this forum but....bump?....