Extracting cells from one file to another.

DoodleSmeister

New Member
Joined
Apr 12, 2018
Messages
1
Good day all,

Am having a small dilemma. I can drag data from one file to another, very easily where the filenames etc are static, however, my partner, uses a blank quote spreadsheet, which she then saves per customer, in customer folders.

However, what I would like to be able to do, is create an invoice template, and then be able to load any quote file into it.

The quote page currently looks like :

X4CpB8k.png


The Invoice page will likely have a very similar layout, however, I am not too worried about that, as I will reference all the right cells from the quotes pages into the Invoice.

I hope this is enough information, and any help would be very much appreciated.

Many thanks.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,214,649
Messages
6,120,732
Members
448,987
Latest member
marion_davis

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