LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Command for posting entry to the next empty cell

Hello, Sorry I do not use Excel on a day to day basis but in the past
have got away with using the macro recorder feature as a way to
automate some tasks and frig it to work by editing it somewhat in the
VB editor. In this case however I am uncessful

This Is what I want to have a macro for

Select a range of cells
Copy them
Do a special paste into the currently selected space

What I want to do is paste them into the next BLANK Space below the
list of entries so its like a running log so I can play the macro once
a day to have a running history of values and plot them on a chart.

Anybody who can help me with this will be a life saver.

If you need more info let me know

(Picture representation below
___________________________________
|__A___|___B___|____C___|_____D____|
|dddddd|ddddddd|dddddddd|dddddddddd|
|dddddd|ddddddd|dddddddd|dddddddddd|
|dddddd|ddddddd|dddddddd|dddddddddd|
|dddddd|ddddddd|dddddddd|dddddddddd|
| | | | |<-----Should automitically post in
here
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Double Entry Posting Moe Excel Worksheet Functions 1 December 1st 09 03:40 PM
fill in empty cells with previous entry in column allan Excel Discussion (Misc queries) 2 August 13th 09 05:49 PM
the owner of posting should be able to delete the posting Mahendra Excel Discussion (Misc queries) 7 August 8th 05 07:21 PM
No entry in cell J10 if cell J7 is empty KimberlyC Excel Worksheet Functions 7 May 7th 05 08:41 PM
Command button on data-entry form Susy Excel Discussion (Misc queries) 1 February 15th 05 01:46 AM


All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"