LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default cell value based on selection from drop box

I have a worksheet with a drop box list, containing names of sheets (B2). I
want the cells in B3:F4 to carry a duplicate of the same cells from that
sheet name. Can anybody help me with a formula or macro for that purpose?

TIA
Esra

 
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
count based on selection from drop down list lovejunkie02 Excel Worksheet Functions 2 September 21st 07 10:04 PM
Based on Drop-Down Selection go to that Section on Sheet Golova Excel Discussion (Misc queries) 3 April 17th 07 07:26 PM
Hide row(s) based on drop down selection Maritza Excel Discussion (Misc queries) 6 March 12th 07 09:56 PM
Change row colour based on the drop down selection Sathya Nallapeta Excel Discussion (Misc queries) 1 January 4th 07 11:12 PM
Drop Down Lists - assign a value based on selection Neil M Excel Worksheet Functions 6 November 19th 05 03:25 PM


All times are GMT +1. The time now is 07:17 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"