LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Referring the cell instead of typing the sheet name

Hi,

I'm just preparing a summery sheet for an work book that contains more
then 60sheets (date wise)

In Column B7 - Sheet Name(i.e. 26th April

In Column C7 to G7 - Array Formula (i.e. {='26th April'!C21:G21})

In Column J7 to N7 - Array Formula (i.e. {='26th April'!J20:N20})

Is there any way to change the formula in a way to just drag down the
formula by referring B cell instead of typing the sheet name in the
formula.

Thanks in anticipation....

Vinu.
 
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
putting date in a cell referring to the tab sheet Rachel Excel Discussion (Misc queries) 1 November 6th 09 06:16 PM
referring to a sheet in another file Tami Excel Worksheet Functions 1 May 31st 08 01:56 PM
Referring to a variable cell on another sheet PaladinWhite Excel Worksheet Functions 5 March 24th 08 02:14 AM
Formula referring to a different sheet luvthavodka Excel Discussion (Misc queries) 1 November 12th 06 10:05 PM
referring to previous sheet Iolao Excel Discussion (Misc queries) 3 November 26th 04 08:40 PM


All times are GMT +1. The time now is 02:29 PM.

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"