Recording a Marco

[Pat]

Hello,

I am recording a Marco where data is being moved from one mothly tab to the
next monthly tab. I need to pull only "current" data forward. I am using
the end down feature however each month (and each individuals) data being
moved will not always be on the same line. When I recorded the macro and
reviewed in visual basic I can see that it has recorded a specific cell to
begin the copy funtion.

I know there is a way to record it so that it is not cell specific.

Any suggestions would be greatly appreciated. ??

 

[Sheeloo]

To record a macro that uses relative cell references, click Relative
Reference on the Stop Recording toolbar.

See http://support.microsoft.com/kb/213740 for details....

 

[Pat]

Thank you!! I will try this on Monday.
Have a great weekend.