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

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

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