LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
TD TD is offline
external usenet poster
 
Posts: 29
Default Formula to extract data from other worksheet

My problem is this. The following formula:

=(('Budget MRS 2007'!$H6*'Budget MRS 2007'!$H7)+('Budget MRS
2007'!$I6*'Budget MRS 2007'!$I7)+('Budget MRS 2007'!$J6*'Budget MRS
2007'!$J7)+('Budget MRS 2007'!$K6*'Budget MRS 2007'!$K7)+('Budget MRS
2007'!$L6*'Budget MRS 2007'!$L7)+('Budget MRS 2007'!$M6*'Budget MRS
2007'!$M7))/I6

Is extracting data from one sheet "Budget MRS 2007" and returning a result.
But I need to use this formula to calculate a lot of data. The above formula
e.g. use cell H6-M6 and H7-M7 but I need results for H11-M11 and H12-M12 and
so forth it increases with 5 cells everytime.

Is there a smart way that I can make a formula or something, so that I don't
have to manually change the cellnumbers that excel needs to extract data
from, but make excel realize that it need to take 5 cell steps every time.

Hope this makes any sence or else dont hesitate to write back for further
explanation.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract data from table in other worksheet Crazy Excel Discussion (Misc queries) 3 July 7th 07 10:29 AM
Extract data from one worksheet SKY Excel Worksheet Functions 5 April 27th 06 01:48 PM
Using a column of data from 1 worksheet to extract data from another worksheet [email protected] Excel Worksheet Functions 2 February 23rd 06 04:33 PM
Extract data from one Worksheet to another extract data fr. one worksheet to anothe Excel Worksheet Functions 1 August 15th 05 07:11 PM
extract data from worksheet sallu Excel Worksheet Functions 2 February 21st 05 06:50 AM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"