Search : in
By :

Paste data into next available row

Last answer on Nov 5, 2009 3:47:03 pm GMT davekrohne, on Nov 4, 2009 7:57:41 pm GMT 
 Report this message to moderators

Hello,
I am attempting to create a macro that copies the data in sheet1 cells b2-b7 into sheet2 row A, but then tomorrow, when the data in sheet1 is updated, it pastes this data into sheet2 in the equivelent cells in the row below e.g. row B (even if there is currently data in row B). I know this is possible, I just can't my head around it from where i'm sat.

Any help would be appreciated!

Thanks

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Paste data into next available row » in :
How to split data into multiple worksheets? ShowHow to split data into multiple worksheets? Issue Solution Note Issue I hope someone can help! I have a .csv file open with excel that contains a large amount of data that has been merged together so that each data set follows each...
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
[MySQL]Loading a text file into ue table Show[MySQL]Loading a text file into ue table To load a text file as follows: $ tail /home/user1/test.txt 'name1',1,9 'name2',2,3 'name3',3,54 'name4',4,2 'name5',5,9 In a table defined as follows: CREATE TABLE...
Download USB pc lock Show
Download Excel-MySQL converter ShowHenceforth with Excel-MySQL Converter, it is not necessary to be a developer to be able to convert Microsoft Excel data into MySQL database or vice versa. This program allows you to convert quickly your data without using other material. Depending...
Download Excel2mysql Show
Graphics cards - Video cards Show2D Accelerator Cards A graphics card, sometimes called a graphics adapter, video card or graphics accelerator, is a computer component which converts digital data into a graphical form which can be displayed on a monitor. The initial role of a...
Backup ShowBackup Setting up a redundant architecture ensures that system data will be available but does not protect the data against user-introduced errors or against natural disasters such as fires, floods or even earthquakes. Therefore it is necessary to...
Uuencode/Uudecode ShowUuencoding UUencode encoding (a contraction of Unix-to-Unix encode) is an algorithm for converting 8-bit binary data into a 7-bit format. Uuencoding was originally created for sending binary files using the email protocol uucp. The uucp system...
Ask your question Reply

1

 aprpillai, on Nov 5, 2009 7:00:20 am GMT

Hi,

First of all you are referring A, B etc. as rows, the correct term is Column. I think you should include Code in your macro to check and validate for Cell for Empty contents from left to right and when you hit empty cell in a column paste the values in that column.

This will ensure that each time the copied data are pasted into the next empty column.

Regards,

   
Reply to aprpillai
Ask your question Reply
They need your help