Ask your question Print Format Forum list Help them Statistics Search Charter Forum Office software

Moving data to the next empty cell

Last answer on Sep 17, 2009 9:20:43 pm BST ffgibbs, on Jul 8, 2009 5:57:06 pm BST

Report this message to moderators

Hello,

I am realitively new to writing code in excel. I have a button that when i click it it moves data from one cell that has done a calc to another cell as a holding place. I don't want to lose that data but need to go to the next empty cell below the first holding spot when I have further data to hold. The command below works for the first part but overides the next calc data.

How can I make this go to then next empty cell?

Private Sub CommandButton2_Click()
Sheets("sheet2").Range("N15") = Sheets("sheet2").Range("c18")
End Sub

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Moving data to the next empty cell » in :

This page

Select ActiveCell.Offset(1, 0).Range("A1"). I have used this in an Read more

Ask your question Reply

Musicgal, on Jul 31, 2009 1:55:22 pm BST

Select
ActiveCell.Offset(1, 0).Range("A1").

I have used this in an Excel spreadsheet to select the next lower cell in column A (after pasting data from one spreadsheet to another and transposing the data). It's been awhile since I created the macro, but seems there is a "relative reference" component. Hope this helps.

Reply to Musicgal

Rob, on Sep 17, 2009 9:20:43 pm BST

Thank you for the information on July 21 of this year. But, was wondering if it can work on a different worksheet.
My hospital uses a check request form created in Excel and now a department wants to create a spreadsheet with only 4 of the fields i.e. Date - Company - Invoice # - Amount .

These are part of the originial form field and we would like another worksheet with these as headers and of course populate the information no matter how many times those fields are changed. I can use =(sheet1!H10) and it will have the same information until I add a new check request with different Dates - Company - etc.

The new worksheet will have the field headings but needs to move down one row once the origianl form is saved or changed?
Thanks in advance - ROB

Reply to Rob

Ask your question Reply