update linked cell when new data is inputed into linked cells

bohon79

New Member
Joined
Jul 2, 2015
Messages
28
Good Morning,

Maybe you all can help. I am pretty sure that this can be done but can not figure out the formula to work.

I have a excel sheet that has multiple sheets in it that is linked to the overall main sheet. have it where it is linked as to when data is inputted on one sheet it updates that data on the main sheet. I know how to link the cells between sheets but having problem linking multiple cells in one sheet to one cell in another sheet so when new data is inputted in one cell it updates the data in another cell on another sheet.

example:

Sheet 1 cell name:
cell %

Sheet 2 cell names
PP1
PP2
PP3
PP4
etc.

Each cell on sheet 2 is based on pay periods (PP1 Cell is pay period 1, PP2 is pay period 2 and so on). So when PP1 is entered, Cell % on sheet 1 is updated. The Next week when PP2 is updated, Cell % is updated based on PP2 entry. I do not want it to add it to the Cell # on sheet 1,m but overrided that data.

any help would be greatly appreciated.

thanks.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

C Moore

Well-known Member
Joined
Jan 17, 2014
Messages
544
Office Version
  1. 365
Platform
  1. Windows
Sounds like you want a Worksheet Change event macro. Google that.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,631
Messages
5,597,282
Members
414,134
Latest member
Snowfall

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