Hello,
I am new to the group and also just learning about macros. Is there a hady reference which might serve as a starting point.

Also I need some assistance with creating a macro.

I have a spreadsheet which is updated from an external data source. This spreadsheet can be called the Superset(Say 1500 rows). The data is updated daily from a main frame.

I have another spreadsheet which contains a subset(say 500 rows) of the items in the superset.

I need to find a way to automatically copy some of the information for the 500 rows from the superset to the subset.

Any pointers or help would be very much appreciated.

Thanks,
S.

Please provide some more detail about what you are trying to do.

Consider using Data Query instead of macros.

That way you can do a data query, match the data, and then automate the process