have an excel query
 

hi there

hope someone can help

I am doing a project at the moment. I have about 10 different worksheets
relating to 10 different counteries and need to fill in the prices of a
number of different products.
what i then need to do is insert all of these new prices into a master file,
which is already created with the product names...but i need to transfer the
prices to this master file..
hope i am making sence? any eacy way to do this??

Tks, L

have an excel query
 

easy,but you will have to give us more info.I assume you are inputting new
data into your seperate worksheets and that your master file also brings in
this new data....So we need to know how your 10 worksheets look and your
master sheet.
just give as examples of how things are arranged and the type of data ie
numbers words etc...
--
paul

remove nospam for email addy!



"lmlm" wrote:

hi there

hope someone can help

I am doing a project at the moment. I have about 10 different worksheets
relating to 10 different counteries and need to fill in the prices of a
number of different products.
what i then need to do is insert all of these new prices into a master file,
which is already created with the product names...but i need to transfer the
prices to this master file..
hope i am making sence? any eacy way to do this??

Tks, L

have an excel query
 

hey Paul

Thanks for the very quick reply

In each of the seperate files I need to fill in the new 2007 price
Product Code 2006 Price 2007 Price
EC-2000 $10 $12

Now, in the master file there is 1000's of products and they are all mixed
up, so want to be able to insert what I did in each of the seperate
worksheets to the master file

which will have similiar colums...

again, tks for taking the time to help me on this
L

"paul" wrote:

easy,but you will have to give us more info.I assume you are inputting new
data into your seperate worksheets and that your master file also brings in
this new data....So we need to know how your 10 worksheets look and your
master sheet.
just give as examples of how things are arranged and the type of data ie
numbers words etc...
--
paul

remove nospam for email addy!



"lmlm" wrote:

hi there

hope someone can help

I am doing a project at the moment. I have about 10 different worksheets
relating to 10 different counteries and need to fill in the prices of a
number of different products.
what i then need to do is insert all of these new prices into a master file,
which is already created with the product names...but i need to transfer the
prices to this master file..
hope i am making sence? any eacy way to do this??

Tks, L