Thank you!! I will try this on Monday.
Have a great weekend.
--
Thanks, Pat
"Sheeloo" wrote:
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....
--
--------
If this is what you wanted then press the ''''YES'''' button (if you see it)
"Pat" wrote:
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. ??
--
Thanks, Pat