Writing a Macro with VBA

Hewlett-packard / Pavilion dv2000
January 7, 2009 at 12:43:10
Specs: Windows Vista, Centrino/3 GB Ram
I need to write a macro that will Match data in ColumnC Sheet1 with ColumnA Sheet2, follow same row over in Sheet2 to ColmnG and copy that data to ColumnO Sheet1 corresponding with ColumnC Sheet1, using loop for 11280 cells. Any help would be much appreciated!!

See More: Writing a Macro with VBA

Report •

January 8, 2009 at 05:40:02
why use a macro? If I understand your request correctly, you can use


Entered in sheet1 cell O2: can then be copied down.

Note Indirect() is what's known as a volatile function (it recalculates every time you do anything on the sheet), so it might be worth using copy/paste special/values afterwards for speed reasons.

Report •

January 8, 2009 at 08:21:21
Thanks for the information. I did that exactly. Copied down ColumnG of sheet 1 and I only recieved the last 3 cells with information. I did go and see if anything else matched and they do. What might cause this to happen?



Report •

Related Solutions

Ask Question