copying bold data from sheet1 to create new
worksheets and rename the worksheet using the bold
data in sheet1
-can anyone help me to solve this problem?
Please Login or Register to view this content.
copying bold data from sheet1 to create new
worksheets and rename the worksheet using the bold
data in sheet1
-can anyone help me to solve this problem?
Please Login or Register to view this content.
Last edited by ramdzan; 03-10-2011 at 10:01 AM. Reason: add code tags
Maybe:
Please Login or Register to view this content.
Please remember to use code tags when posting code to the forum per the rules
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
You need to add code tags.
Hi,
Any chance you could upload a sample of your workbook so we can see what is happening?
Dom
ok.. here it is..
Attachment 100705
Something seems to have gone wrong attaching the file.
Dom
So do you want a sheet creating for each bold entry in column D? What was the significance of the j variable in your original code?
Some of the entries on column D aren't valid sheet names like ''GOLDEN TIER SDN BHD (A/C 2)' which would need to be dealt with.
Dom
I suppose the j variable is for the number of the worksheets..
So if i want to add sheets and rename the worksheets base on the
name of the companies, how the code was suppose to be?
Last edited by ramdzan; 03-01-2011 at 11:39 AM.
So you only want to add 7 worksheets?
Dom
no, actually the code i post is just for testing.. the number of sheets is the same as th number of
the companies.. about 67 sheet..
Something like this then maybe:
Please Login or Register to view this content.
Dom
can i know how to remove the attached file?
I meant to say I thought that might be sensitive data. Send a message to one of the mods and they'll sort it out for you.
Did the code work for you?
The code work.. thx Dom =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks