hi all - not sure how to tackle this, i keep thinking a formula inserted into a cell via macro but converts to text but not sure......
On sheet named Register in Column A is a number series. We use this number to assign a unique number to a change made.
Currently I have to drag the numbers down to fill.... but we now need to somehow set this up to reflect the current year.
is there a way by macro, to find the next empty cell in column A and input the value PCR21001?
then when a new change is entered, the macro finds next empty cell again and enters PCR21002 and so on.
how do i then stop or change the cell so that when we go to the year 2022 that all of the numbers already in the sheet stay as PCR21xxx
cell A1 can be used as a date reference if needed.
hope this makes sense and TIA for any help
On sheet named Register in Column A is a number series. We use this number to assign a unique number to a change made.
Currently I have to drag the numbers down to fill.... but we now need to somehow set this up to reflect the current year.
is there a way by macro, to find the next empty cell in column A and input the value PCR21001?
then when a new change is entered, the macro finds next empty cell again and enters PCR21002 and so on.
how do i then stop or change the cell so that when we go to the year 2022 that all of the numbers already in the sheet stay as PCR21xxx
cell A1 can be used as a date reference if needed.
hope this makes sense and TIA for any help