brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have sheet named "Master". I then have a number of sheets named according to my Customer number 1001,1002,1003 etc.
I am entering information on the Master sheet which includes the client number in cell B2 on the Master sheet but in number format.
When I run a macro (still to be written) I want to copy what I have entered on the Master sheet in cell C2 to the next empty row on the Client sheet which is referenced in Cell B1 on the Master sheet. I can do the rest of the coding but do not know how to move to the sheet name entered in cell B2 in number format
Can someone please assist
I am entering information on the Master sheet which includes the client number in cell B2 on the Master sheet but in number format.
When I run a macro (still to be written) I want to copy what I have entered on the Master sheet in cell C2 to the next empty row on the Client sheet which is referenced in Cell B1 on the Master sheet. I can do the rest of the coding but do not know how to move to the sheet name entered in cell B2 in number format
Can someone please assist