Merge - Create New Sheets - HELP!!!

M

mpalmer

I have a worksheet with a price list on it. I also have a sheet wit
names and addresses in rows.....column names are Customer Name
Address City State

What I want to accomplish is to end up with new worksheet tabs for eac
customer name - with the Customer Name , address ect shown on eac
worksheet that contains the pricing. Hopefully that makes sense....
 
M

Mike

There is a limit on the number of characters on a worksheet tab. Anyway, you
got a lot of work ahead of you. And the number of tabs you can have will be
limited to available memory. Having one customer on each worksheet is not
the way to go. Access would be the best tool for what you want. If you have
more than 50 customers you are heading for a complete distaster.
 
Top