Next "available" Row

[Excelnoub]

Using Excel 2003

The following code need tweeking:

Code:

Please Login or Register  to view this content.

I need Sheet1 to copy any information inserted in Colunm A to be copied to the the next "Available" row.

Example if I add in Sheet4 in row5 in Cell C5 lets say the work "Done", I need, when I go back to Sheet1 Row5 Cell A5 and add, let's say "complete", to go to the next "Available" Row in Sheet4. The result should be A6 but it doesn't do this... HELP

[rvasquez]

Hi there,

Could you please attach a sample of your worksheet?

Thanks,

RVASQUEZ

[Excelnoub]

It won't upload due to my work admin rights but I can cut and paste the the codes from every sheets in here?

[john55]

please info us that you cross posted here
http://www.mrexcel.com/forum/showthread.php?t=624941

[Excelnoub]

Sorry about that:

Also see: http://www.mrexcel.com/forum/showthr...=624941&page=2

[rvasquez]

Hi there,

I have attached a macro enabled spreadsheet that runs a macro that adds the last entered value in column A to the first empty cell in column A of worksheets 2,3,4 and 5.

I wasn't quite sure if this is exactly what you were trying to do but you should be able to alter the code to fit your needs.

Please let me know if you have any questions.

Thanks,

RVASQUEZ

[Excelnoub]

I have posted all my codes at the following link:

http://www.mrexcel.com/forum/showthr...=624941&page=2

[Excelnoub]

Here is my excel work sheet (Excel 2003)VBA Testing.xls