slamet Harto
09-17-2008, 07:39 PM
Dear Expert,
Following my previous post with tittle "Split By text", herewith
I want to create an automatic number or value only if in column B type of value is Ritz . then save the last number/value in lastrow to range H1. So, every time we run a macro then range H1 will be a lastnumber value. Example: if yesterday value in range H1 is 6, than today the value will be started from 7 to ... defending on how many row in column B that containing type a word of Ritz.
I'm assuming, we need to sort all data in range A5:P13 and insert a column in column C then run a macro to generating a number.
However, I need the number is not a number but a text value. for example the number is 1 then it will be replaced into '00001.
Another process/step is we split the all data into sheet 3 and sheet 4 based on criteria.
Please advice me on how the vba code to do this.
Thank you so much for your assistance.
Rgds, Harto
Following my previous post with tittle "Split By text", herewith
I want to create an automatic number or value only if in column B type of value is Ritz . then save the last number/value in lastrow to range H1. So, every time we run a macro then range H1 will be a lastnumber value. Example: if yesterday value in range H1 is 6, than today the value will be started from 7 to ... defending on how many row in column B that containing type a word of Ritz.
I'm assuming, we need to sort all data in range A5:P13 and insert a column in column C then run a macro to generating a number.
However, I need the number is not a number but a text value. for example the number is 1 then it will be replaced into '00001.
Another process/step is we split the all data into sheet 3 and sheet 4 based on criteria.
Please advice me on how the vba code to do this.
Thank you so much for your assistance.
Rgds, Harto