Update formulas on multiple worksheets feeding from another

TenCO

New Member
Joined
Jun 19, 2012
Messages
10
I have a file that lists the months in columns and several vendors as rows. Each month I put in their sales figures, which then is used to calculate fees we charge them in a couple rows below. For each vendor, I have a separate worksheet that has an invoice template that pulls the fee over from the main worksheet. Each month I manually adjust each vendor's worksheet to refer to the fee in the next column over (because the following month's fee is in the next column) Is there anyway to do this easily? (not every worksheet invoice is uniform - the cell where the fee is put in is not always the same cell #)

Thank you!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

nise23

Board Regular
Joined
Jan 6, 2012
Messages
65
Assuming that you have the month that the invoice is for listed somewhere on the vendor worksheet, you should be able to use the HLOOKUP function to look up the value. It basically would look for the month in row 1 of the worksheet with the sales figures and you would tell it how many rows below the month the value is that you want on the other sheet. So once you have the formula in place all you would need to do is change the month or the date (depending on how the formula is written) on the template sheet and it should update the sales value accordingly.

Without wanting to judge your knowledge of Excel, I would like to mention that understanding VLOOKUP and HLOOKUP will greatly benefit anyone that works with Excel frequently, so if you are not familiar with these functions, I recommend looking into them...

-nise23
 

Watch MrExcel Video

Forum statistics

Threads
1,129,563
Messages
5,637,073
Members
416,956
Latest member
mitzhaki

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
Top