# Trying to combine two spreadsheets, not sure how

#### brianb1980

##### New Member
Okay, here’s my problem. I’ve got a spreadsheet that I built a couple years ago to help me estimate gas loss from pipeline blow-down situations, which are everyday occurrences. On this particular spreadsheet, I have a pull-down menu for all the locations that can be blown down. I select a location, enter a few variables such as starting and ending pressures, temperature, etc. Then, it gives me a value in Mcf (thousand cubic feet). In the examples I’m showing below, I’m dealing with pig trap blow-downs. This works perfectly for me on a single blow-down basis, but when I have multiple blow-downs to figure, which happens daily, I have to do each one individually.
<o></o>
I have another spreadsheet where I then input all the information from each blow-down and I have it doing some very simple calculations, such as adding up how many pigs we ran, how much gas was lost, how much water was pigged out of the lines, etc. This is a good way to keep track of everything all in one place, and I’m able to track an entire year in each workbook. I have tabs named JAN, FEB, MAR and so on, and then one called YTD for all the cumulative calculations so we can see where we stand at the end of the year.
<o></o>
So what I’m looking to do is combine the spreadsheets into one. Usually, spreadsheet building is something I tend to not have many problems with. This, however, is proving to be a task for me. Mainly because the workbook I use to do the gas loss calculations has a separate worksheet where the calculations are done behind the scenes. And those calculations take up quite a bit of real-estate. So, I just can’t figure out how to make this work. I’m not sure if it’s going to require VBA to make it work, or if it can be done with formulas.<o></o>
<o></o>
I hope my problem is making sense. If not, and anyone needs further clarification, please ask and I’ll do what I can.

Sorry, I had screen shots but since I don't have them saved as URLs anywhere, I had no way to post them... as far as I know.

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Replies
9
Views
435
Replies
2
Views
219
Replies
9
Views
263
Replies
0
Views
86
Replies
0
Views
302

1,211,679
Messages
6,103,245
Members
447,849
Latest member
4chase

### 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.

### Which adblocker are you using?

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

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