Dear Sir,
I need a VBA code to increase the references in one of the cell.
Example;
i am filling various fields of the excel"sheet1" and running VBA macro to share the details in another sheet"Sheet2" as row. this is done through VBA macro
In my sheet 1 - cell B4, I need the references to appear as B001 and for every run of above macro, i need the B4 cell to change as B002.... and so on with every run of VBA macro.
Note: since this B001 is getting recorded in sheet 2, you can use of this to get the next reference in Sheet1 cell b4
Please support in providing the Macro VBA code for this.
Thanks
Anwar
I need a VBA code to increase the references in one of the cell.
Example;
i am filling various fields of the excel"sheet1" and running VBA macro to share the details in another sheet"Sheet2" as row. this is done through VBA macro
In my sheet 1 - cell B4, I need the references to appear as B001 and for every run of above macro, i need the B4 cell to change as B002.... and so on with every run of VBA macro.
Note: since this B001 is getting recorded in sheet 2, you can use of this to get the next reference in Sheet1 cell b4
Please support in providing the Macro VBA code for this.
Thanks
Anwar