1st) i download 4 different sets of data from our stores on a nightly basis.
I insert that days sales data into a template. One store may only have 50
transactions where another may have 200. The template has some preset
formulas in them to calculate margins and costs to the transactions. When I
sort the new data the formula line may be anywhere from line 400 to line
1000. How can i insert a macro so it knows to look for the formula line and
then copy down to include all of the transactions? I think has something to
do with absolute references versus relative references, but I have not
figured it out yet. Thanks for the help

2nd) When I first open up to run a macro the little recorder icon remains on
the page. But if I screw up and need to rerun it, it disappears and then I
have to go back into tools to stop the recorder. Why is this happening, and
how do I keep the recorder on the page?

Thanks in advance,


--
inthestands