Formula Question

[Guest]

Hello,

I need to do the following:

I have 2 seperate Excel files, one named Quotes.xls and the other is Sales.xls
In Quote.xls I have data in cells A12:H12 across to A45:H45 down.

I need to be able to copy that data into sales.xls but have it be able to put
an extra row in between each copy of data. I need to able to update the
sales.xls
file every day with new data being entered into the quote.xls file. The
sales.xls
file will keep all data in it and the quote will be changed frequently.

I hope this makes sense.

Thank you so very much

Kent

 

[Guest]

Ok, the extra row thing is throwing me but I think I can help you get started.
Open both workbooks.
In Sales.xls let's say that you want the data from Quote.xls to appear on
Sheet1 starting in cell A1.
In Sales.xls Sheet 1 cell A1 enter = to start the formula. Then go up to
Window and select Quote.xls. In Quote.xls click once on the cell A12 then
hit enter.
The forumal will look something like this: =[quote.xls]Sheet1!$A$12

The data appears in Sales.xls and everytime you update the information in
Quote.xls the change will be reflected in Sales.
Redo the steps for each cell in Sales.xls that you want data from Quote.xls
to appear. I am assuming that this would take care of the extra row because
you can enter the formula into any cell in Sales and have it pull data from
any cell in Quote.

Hope this helped.

 

[Guest]

Hello,

Thank you so very much for your response. I tried that and it works great.

But I need the data in the quote.xls to be only updated on certain days of
the week in the sales.xls file.

Is there a button I can create that would copy a certain range of cells
in quote.xls into sales.xls only when I need them to?

The extra row thing is like this:
Lets say that I copied the data in quote.xls from A1 to G25. So in the
sales.xls
file I need to have a blank row between each copied data. Does that make
sense???? I apologize if it does not.

Thank you so very much

Kent

Ok, the extra row thing is throwing me but I think I can help you get started.
Open both workbooks.
In Sales.xls let's say that you want the data from Quote.xls to appear on
Sheet1 starting in cell A1.
In Sales.xls Sheet 1 cell A1 enter = to start the formula. Then go up to
Window and select Quote.xls. In Quote.xls click once on the cell A12 then
hit enter.
The forumal will look something like this: =[quote.xls]Sheet1!$A$12

The data appears in Sales.xls and everytime you update the information in
Quote.xls the change will be reflected in Sales.
Redo the steps for each cell in Sales.xls that you want data from Quote.xls
to appear. I am assuming that this would take care of the extra row because
you can enter the formula into any cell in Sales and have it pull data from
any cell in Quote.

Hope this helped.

Hello,

I need to do the following:

I have 2 seperate Excel files, one named Quotes.xls and the other is Sales.xls
In Quote.xls I have data in cells A12:H12 across to A45:H45 down.

I need to be able to copy that data into sales.xls but have it be able to put
an extra row in between each copy of data. I need to able to update the
sales.xls
file every day with new data being entered into the quote.xls file. The
sales.xls
file will keep all data in it and the quote will be changed frequently.

I hope this makes sense.

Thank you so very much

Kent