Auto-populate next available cell

Hi all

Is there a function which would allow me to auto populate the next avaible free cell in column A (sheet 3) with data from column A (sheet1) and column A (sheet2)?

This would be a shared workbook and sheet 3 needs to be updated dynamically with data as its entered. The data is numerical and unique


Any help is appreciated

Thanks

Hi Bigbadlee,

What type of calculation would you like to do on Sheet 3?

Do you only want to replicate data that is on Sheets 1 & 2?

If you can give me a little more info abt the data that you want to appear on Sheet 3, I could probably help you.

Mike

Hi mike,

This is my workbook

Monthly Workflow Mark 2.xlsm

I need the job numbers from 'Digital' and 'Litho' to appear in the Job numbers column in 'Progress'. At the moment you have to manually enter the number to trigger the VLOOKUP functions.

So if 52001 is entered into Job numbers in 'Digital' it appears in 'Progress' in the first available cell. Then if another job number is entered in 'Litho' it goes underneath 52001 in 'Progress'

Hope this makes sense

I'll try to simplify what I would like.

I have 3 worksheets on a shared workbook. Sheet1 and Sheet2 have random unique numbers input by 2 separate operators into column A (1 worksheet for each operator). I would like for Sheet3 (column A) to be the master column which would have data from both sheets as it is input.

Example of data:-

10001
12312
13456
13331

Thanks