Linking two sheets (Excel 2000)

db49ers

Board Regular
Joined
Oct 13, 2002
Messages
97
I have two sheets in a workbook that I want to link and I need some help. Sheet1 will be input and Sheet2 will compute entries.
Sheet1 will have the following:
Column B are dates
Column C are vendors
Column D are dollar amounts
where Rows would be like:
1/1/2002,Dell,$50.00
1/1/2002,Gateway,$100.00
1/2/2002,Dell,$100.00
1/2/2002,Dell,$75.00
Sheet2 will have the following:
A1: 2002
B1: =WEEKDAY(DATE(A1,B2,0))
A2: January
B2: =MATCH(A2,fullyear,0)
Column A are dates but will change if the year is changed:
A11: =IF($B$1=1,DATE($A$1,$B$2,1),"")
A12: =IF(A11="",IF($B$1=2,DATE($A$1,$B$2,1),""),A11+1)
A13: =IF(A12="",IF($B$1=3,DATE($A$1,$B$2,1),""),A12+1)
Row10 are vendors:
B10: Dell
C10: Gateway
What I want to do is have Sheet2 put Sheet1 entries in the correct spot:
B11: nothing
B12: $50.00
C12: $100.00
B13: $175.00
I thought conditional formatting would do it but it will not do it for different sheets.
Thanks for any help! David
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,144,148
Messages
5,722,779
Members
422,457
Latest member
Mrmuskins

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