Menu

Macro - Skipping a line

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Don Guillett

Posts: n/a

Default

Always post YOUR code for comments

--
Don Guillett
SalesAid Software

"PaulPoll" wrote in message
...
I want to make a macro that will automatically skip a line. Each day I
fill
in a cell with a number which changes seven or so various formula cells
residing on one line. I then copy and paste those values to their place
below
the last day's entry. Each day it's the same procedure but the values
change.
I cannot get a macro to find the place it should "paste" the value to
properly. It always copies over and replaces the cells from the previous
day
because it is not moving down a line. Eg. Every day I make an entry to A1
which in turn changes the values in A5 thru H5. I then copy cells A5 thru
H5
and paste those "values" to A6 thru H6. The next day, after entering data
in
A1 that changes the values in A5 thru H5, I again want to record those new
values but I now want them pasted in the line below the previous day's
entry;
I now want them pasted in A7 thru H7, each day moving to the next line
below.
Can anyone tell me what I need to add to a macro to make it automatically
move to the next line? Thank you.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Line chart - date line association gone mad!	Johannes Czernin	Charts and Charting in Excel	5	January 17th 05 08:48 PM
Zip Code Macro	Ken Wright	Excel Worksheet Functions	0	December 9th 04 07:55 AM
Macro and If Statement	SATB	Excel Discussion (Misc queries)	2	December 3rd 04 04:46 PM
Macro Formula revision?	Mark	Excel Worksheet Functions	1	November 28th 04 01:43 AM
Macro for multiple charts	JS	Excel Worksheet Functions	1	November 19th 04 03:44 AM

All times are GMT +1. The time now is 12:31 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement