Copying Data

[howard]

I need a macro to copy data from column BA (Named Data1-This column can change when new columns are inserted) and the second & third column to the right of column BA ie BC & BD. This must be copied to the range FinData (columns BH:BJ)

Your assistance in this regard will be most appreciated

Howard

 

[RalphA]

Assuming your data is in the range BA2:BC50, and you want to copy that data to the range BH2:BJ50, then, in BH2, enter =BA2. and copy to the range BH2:BJ50. Now, when you enter new columns anywhere, the formulas should automatically update to reflect the new range that is to be copied.

 

[howard]

Hi Ralph

Thanks for the reply. I managed to write code to do this for me. The imported data changes all the time as new accounts are added, so I thought it would be wise to write a code to automate the process. It was easier than I thought it would be

Regards

Howard

 

[RalphA]

Congratulations, Howard, on your code-writing skills! Me, I'm fairly stomped by VBA, so, I stay away from it.

 

[howard]

Hi Ralph

Still a VBA Novice, but learning all the time.

Regards

Howard