macro that pulls from new row each day

[sscfa]

Is there a code that enables you to create a macro that pulls data from a new row each day from several worksheets within an excel document?

 

[Andrzejek]

How do you know which row is a new row?
Is it the last row?
Or do you have a date in one of the columns?

Have fun.

---- Andy

 

[sscfa]

Hey Andy,
The answer to both of your questions is both. The new row is the last row and it is dated.

Thanks for your help!!!

 

[SkipVought]

What do you mean by, "...pulls data..."?

This can be done with a LOOKUP function or SUMIF or COUNTIF functions right on the spreadsheet.

Check out faq68-1331 for named ranges.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[sscfa]

I need the macro to create a new line below my active data each day and put all of my new information on this line. My macro keeps inserting the information on the same line, so it overwrites previous information. But I need all of the information from previous days.

 

[PHV]

Check the FAQ area of this forum to discover at least 2 ways to get the last row number of a sheet.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886