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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

clipro

Board Regular
Joined
Jan 12, 2005
Messages
195
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:
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
 

winny

New Member
Joined
Jan 14, 2005
Messages
17
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.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

ADVERTISEMENT

Winny,

Fine, but we need an example to help as mentioned in my previous reply.

kind regards,
Erik
 

winny

New Member
Joined
Jan 14, 2005
Messages
17
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
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
 

winny

New Member
Joined
Jan 14, 2005
Messages
17
Thank you again.
Clipro referred me to an excellent instruction site. I just about have it figured out.
 

winny

New Member
Joined
Jan 14, 2005
Messages
17
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
 

Forum statistics

Threads
1,147,690
Messages
5,742,647
Members
423,746
Latest member
Joaogomes

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
Top