How would i populate a master sheet based on a drop down selection that selects other

**dbravo** · 05-02-2014, 03:33 PM

For example, I have a master sheet that has a drop-down list of the months January and February, which have their own sheets. I am trying to populate the sales of the week 1, 2 ,3 ,4 in the master sheet based on the same data for the month chosen. Practice.xlsx

THANK YOU!!

**paulzov** · 05-02-2014, 04:54 PM

Check the attached document. Using a nested IF() will work just fine since you only have 12 possible months. You would just need to continue the same formula string for March, April, etc, and drag down to populate the entire Master sheet.

**dbravo** · 05-02-2014, 04:56 PM

Originally Posted by paulzov

Check the attached document. Using a nested IF() will work just fine since you only have 12 possible months. You would just need to continue the same formula string for March, April, etc, and drag down to populate the entire Master sheet.

Awesome Thank You!

How would i populate a master sheet based on a drop down selection that selects other

LinkBack

Thread Tools

Rate This Thread

Display

How would i populate a master sheet based on a drop down selection that selects other

Re: How would i populate a master sheet based on a drop down selection that selects other

Re: How would i populate a master sheet based on a drop down selection that selects other

Thread Information

Users Browsing this Thread

Similar Threads

Need Worksheets to populate with new entry based on drop down selection from master list

populate table based on drop down selection

[SOLVED] Populate a group of cells below Drop Down Menu based on Drop Down Selection

Used a Master Sheet to Populate to Two Set of Data, with 1 Selection Criteria Each

Populate cells based on the selection from a drop down box

Bookmarks

Bookmarks

Posting Permissions