PDA

View Full Version : Create Sheet



atuljadhavne
06-14-2012, 02:15 AM
Dear Expert

I have Sheet with 150 dealers name and their details like name, address, code, outstanding, bucket, etc...

now what i want, i have one format and as per my format i have to create sheet with dealer name right now i am doing it by mannual and talking more time
is there any macro which is create sheet as per my master list

Bob Phillips
06-14-2012, 02:20 AM
Post a before and after example workbook.

atuljadhavne
06-14-2012, 02:33 AM
how i upload file in this forum?

shrivallabha
06-14-2012, 07:04 AM
Next time when you will reply to this thread, scroll little below before pressing "Submit Reply" and you will see
Additional Options | Manage Attachments.
This option will allow you to attach file.

atuljadhavne
06-14-2012, 09:05 PM
IN attached file Data sheet having dealer data and format sheet having format in which all the data should create separate file.

CodeNinja
06-15-2012, 05:49 AM
Please post what 1 row should look like when done.

Tinbendr
06-15-2012, 07:18 AM
Look at this.

atuljadhavne
06-15-2012, 09:46 PM
i am unable to see attachment as mentioned error showing,

"
To view attachments your post count must be 0 or greater. Your post count is 0 momentarily.
"

shrivallabha
06-15-2012, 10:33 PM
i am unable to see attachment as mentioned error showing,

"
To view attachments your post count must be 0 or greater. Your post count is 0 momentarily.
"
This message appears when you have not logged in. Now that you have logged in, please check.

atuljadhavne
06-15-2012, 10:43 PM
i have attached here my expected result with example

Bob Phillips
06-16-2012, 02:42 AM
Are we supposed to be getting data from the Data sheet and creating new sheets formatted as per the second part of Format, or both parts?

atuljadhavne
06-16-2012, 02:47 AM
i just want to create individual sheet as per data
i have attached here 50 list of dealer and want to create 50 sheet with there name as per my expected format

Bob Phillips
06-16-2012, 05:08 AM
If you just repeat what you said earlier and don't answer the questions I raise then I can't help you.