Copy worksheets

[winny]

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

 

[erik.van.geit]

So, your users enter for instance 15 customers on a userform.
These van be entered all together on the same form.
Where does the information go to?
I suppose to a database with name, address, ...

I suppose that you then want to do something with those 15 entered customers? I think it's filling up the two(?) sheets that you posted. (second sheet starts in column H or is this one single sheet) extracting the information from the database.

I suppose you want to loop through all new entered customers to fill in the sheet(s), print, send, etcetera. It could be the inverse: first in the sheets and then to the database...

So a lot of suppositions.

If you give an example, as simple as possible, for one single customer, we'll first try to achieve that and then expand to a list of customers.

Provide a "screenshot" of your database and of a filled-up-sheet.
We'll do our best.

kind regards,
Erik

PS: if somebody thinks he sees things more clear than me, please go ahead!

 

[winny]

Erik,
Your suppositions are all correct. Example
Customer: ABC Company
Address: 1313 13th Street
City: Houston State: Texas
On a sheet entitled CUS (Customer number form) I need to place the information as something that my billing department can print and access.
On a sheet entitled COS (Confirmation of Services) I need to prin the same basic information along with standard contract language and create a sheet for the customer to sign.
I would love for you to examine the entire workbook, but the HTML maker limited the amount of information I could post to a few rows from one sheet.
If I knew how to create the database and paste the information to a single sheet with as many copies as the user's input (could be as few as 1), then I believe I could figure out the rest.

 

[erik.van.geit]

O, Winny, now I'm having trouble using the HTMLmaker myself. This problem never occured here.

This is what you want to do.
from here
DATABASE
names streets adresses
name1 street1 adres1 done
name2 street2 adres2
name3 street3 adres3

you want to put those items in a preformatted worksheet (contract, invoice, ...) to print, etc...
(if we can do it for one, it can be done for two sheets)

name1 is already done so this row will not be "taken" to the other sheets

you take the data to
SHEET
this is your filledup sheet
first loop
NAME: name2
STREET: street2
ADRES: adres2

second loop
NAME: name3
STREET: street3
ADRES: adres3

is this what should be done?

kind regards,
Erik

 

[winny]

Yes. that is precisely what I am seeking

 

[erik.van.geit]

OK,

Let's start ...
Step by Step.

Post a little bit of your database: headings and some sampledata.
How is it filled up? The easiest would be directly on the sheet.
What do you already have?

In the mean time you can name the cells on sheets CUS & COS which has to be filled up with the loop. choose names like
cus_address, cus_name (on sheet cus)
cos_address, cos_name (on sheet cos)
(so when the sheet will be reorganised sometime, you won't have to rewrite your macro while you will refer to those names)

on the datasheet it will be good to name the columns
choose similar names
data_addresses
data_names

once your ranges are named
you can start recording a macro
goto data
copy first item in first column
goto cos
paste values
goto cus
paste values

goto data
copy first item in second column

until first item last column

OK, so far?

kind regards,
Erik

 

[winny]

Erik,
I believe your comments have provided a blueprint. I have not yet created the database, but am doing so now. I will get back when I have it.

Thank you for your patient assistance.
Winny

 

[erik.van.geit]

OK,

It's good that you'll do the job asking only for assistance.
That's how we learn :wink:
succes will be built up patience and going for a walk every two hours


kind regards,
Erik

please send me a little email when you've posted here: next days my time will be very limited

 

[winny]

Erik,

Thank you. It will take me a few days to follow your suggestions. When I do I will post again. Maybe by then I will learn to use the HTML maker.

Winny