Copy worksheets

winny

New Member
Joined
Jan 14, 2005
Messages
17
I am new to excel and to this forum
I have a workbood that contains 7 worksheets. Two of the worksheets are dependant upon information that the user enters on a userform containing a multiselect listbox. The one worksheet includes the name, address and contact information of the customer. The other worksheet includes not only the contact information, but contractual language that the customer must sign. It is not uncommon for a user to enter as many as 15 customers. I need to copy the two worksheets with the information that the user enters. How can I create worksheets based on the user's information.
As this is my first post, I hope I have clearly expressed my need. If not, I will not be embarrassed or put off by your questions and criticism.

Winny
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
hi winny,

welcome to the board,

I am not sure that I can understand your question
what do you mean with
How can I create worksheets based on the user's information.

you just want to copy the sheets or you want to create a new sheets with extract of the information etc.

I am also green on the board but if a can i will help you
:rolleyes:
 
Upvote 0
Winny,

WELCOME to the Board!

This is a large question for a "Boardstarter" to my sense...
Do you need to put together some data from two databases into one sheet?

Can you provide an example of the worksheets and what the result must be? (so BEFORE and AFTER)
Use Colo's HTML Maker utility for displaying your Excel Worksheet on the board. You'll find that at the bottom of the page.

kind regards,
good luck on this Forum
Erik
 
Upvote 0
Thank you for the reply. The worksheets I want to copy have basic form information already included. In fact, want to create new sheets based on the information.
 
Upvote 0
Erik,
Thank you again. I have never been excessively dense, but I am having trouble trying to figure out how to use HTML maker utility. Please bear with me.

Winny
 
Upvote 0
Winny,

Yes, as a beginner it can be a lot to do: but that's the only way we can see what you want.
(unless you post some "words-in-form-of-tables" like
1.......2.......1
Abc....jhe.....pio
but in your case it will be difficult to understand)


instead of clicking "Excel Questions" on the main page there is another link for al kind of questions on htlm-maker ...
http://www.mrexcel.com/board2/viewforum.php?f=9

here is not the place to do that
only in brief:
you download the HTML-maker
you UNZIP (is it zipped, I can't remember)
you load it into Excel
(just click to open is what I do)
a new menu is appearing
select range to post: use the menu
the best is to send only one table per post

be patient and you'll succeed to use it

regards,
Erik
 
Upvote 0
Thank you again.
Clipro referred me to an excellent instruction site. I just about have it figured out.
 
Upvote 0
I am not sure if this part is what I should be posting. The information listed is the information I need to place on the two worksheets
PRMFLTCONSUM Practice book12-14.xls
ABCDEFGHIJK
17CUSTOMER
18
19NameofCustomer[SELECT]
20AirlineStationManager:[EnterNameHere]
21BillingAddress:AccountsPayableAddress:
22Address:Address:
23CityState:CityState:
24ZipAttn:ZipAttn:
25Telephone:Telephone:
26
27
28
29
THE FORM
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top