fill next blank cell from one cell w/o changing previous cells

[doodle72]

I have 2 sheets in a workbook. On sheet 1 I have the same cell that changes weekly. I would like this information to fill the next blank cell in the column on sheet 2 w/o changing the prior cells.

[Jakobshavn]

You could use an event macro. I have attached a sample file. Macros must be enabled for this to work

[doodle72]

the sample sheet seems like that would be great but I am not that familar with macros. I actually have 3 different cells on sheet 1 that will change weekly that I need the data to fill 3 columns (column per cell on sheet 1) on sheet 2 that need to fill next blank cells.

[Jakobshavn]

Very good! Either upload your workbook and I will add the macros or give me details about the three cells and will update my tiny sample.

If you would rather install the event macro yourself, here are instructions:


Because it is worksheet code, it is very easy to install and automatic to use:

1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you have any concerns, first try it on a trial worksheet.

If you save the workbook, the macro will be saved with it.


To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

Macros must be enabled for this to work!

[doodle72]

Sorry for the delay in getting back to you. Hope you are still willing to help I have attached the sheet. On the sheet "hours" there are 3 cells that I need to fill the cells on the next sheet "sheet 1"
I have the cell on "hours" tab to corresponding color cells on the "sheet 1" tab.

[Jakobshavn]

I have downloaded your workbook.

Which are the three cells in the hours worksheet that you are going to be updating??

[doodle72]

in the top left the red cell for date, then the yellow cell beside "salary" then the green beside " total packaged"