Data validation list question

[xoxonutty]

Hi All, i'm a newbe so bear with me if this question has been asked and or answered already. Is there a formula that i can use which allows me to select different tabs / sheets using a drop down on my main sheet?. Or a series of formulas that allow me to select a sheet from a dropdown, input data on my main sheet and have it populate or copied to the sheet with the name I selected. Thanks in advance for any help offered.

 

[mumps]

You are very welcome. If you want to see the code, right click the "Main" tab and click "View Code". As you can see, it is a very short macro. It is a Worksheet_Change macro which is triggered automatically when you make a change in cell B2. I'm not sure what you mean by:

so I can apply it to any other sheets i add

What exactly do you want to do if you add other sheets?

 

[xoxonutty]

You may use INDIRECT formula for this
Example:

indirect($B$2&"!"&A$3&row(A2))

where, cell b2 has fixed validation for your all sheet names like week1,week2...
Row 3 has column headers (A, B, C, D...)
that means: $b$2 is taking your required sheet/tab
A$3 is checking column number from target sheet from where value will come
Row(A2) will check row number from target sheet from where value will come

Regards,
Tarun

Thank you so much, this helps

 

[KUYJS]

You are most welcome

This forum is actually a very nice plateform to exchange knowledge.

 

[xoxonutty]

I will have other sheets / tabs, so basically every sheet/tab will be a different job. At any given time i may have at least 5-10 jobs going. The main sheet will serve as the data entry for the others.

 

[xoxonutty]

Totally agree.