PDA

View Full Version : getting data from sheet 1 to sheet 2



Tenspeed39355
08-13-2006, 06:11 AM
Hi guys I am stuck. How would I get some data from sheet 1 over to sheet2. In sheet1 there is a row of numbers D3 to BD3. I need to subtract D3 from BD3 and then divide by D3. I want the result to be put in
Sheet2 C3. Can I use an Excel formula to accomplish this?? If so what is the formula I put in Sheet2 C3? For some reason I can not get the formula I am using to give me the answer I need. Thanks for your time with this problem.:banghead:
Max

mdmackillop
08-13-2006, 07:08 AM
=(Sheet1!BD3-Sheet1!D3)/Sheet1!D3

austenr
08-14-2006, 11:52 AM
Of course, you need to put the formula Malcomb gave in Sheet2 C3.:hi: