IF Statements

S

scriptjunkie

I have a very large workbook with over 110 spreadsheets within it.

contents:

Master sheet
sheets 1 thru 110

I need the following:

Dropdown located in master sheet at cell g4 listing numbers 1 thru 11
(spreadsheets).

When user selects say number 10 in dropdown list, I need the content
in cells g1,g2,g3 to be entered into the spreadsheet #10 automatically

Hope this makes sense. If not I will try to explain further

Please help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Over time hours 5
formula setup for number combinations 13
nearest match 4
How do I get more than 7 functions in EXcel? 2
Changing info from one worksheet to the next 1
Countif maybe 4
Performing a Lookup with Unsorted Data 1
Copy to another worksheet IF 3

Top