Hi everyone, I have been scratching my head for sometime for this one. Here's the situation I am in.
I have 3 different sheets -
Sheet 1 has a table to put money into different months. Rows denote different amounts of money and columns denote months.
Sheet 2 has a huge table with months, dates, monetary values, quantities and information for all possible outcomes from sheet 1. The data there is fed by Sheet 1. If you select a month & put money amount in sheet 1, only that area is populated in this sheet, and everything else remains empty. What you select on sheet 1 is expanded upon in this sheet.
Sheet 3 is a month by month invoice. It needs a summary of information from Sheet 2. What I need is a formula for this one, where for example - Someone selected January in sheet 1 with 20 dollars, Sheet 2 will give an output for January for 20 dollars with more info.
I need that exact column data in sheet 3 under the month of January, and for all other months to show nothing. And if there is more than one selection in January, it should show that. But if someone selected January 20 dollars and September 20 dollars, only those 2 months should show data under them, and all other months should be empty
I have the entire month by month template of that piece, but I cannot seem to get that data properly from sheet 2 and make the rows empty or auto adjust their heights.
Any guidance and help will be appreciated. Thank you!
I have 3 different sheets -
Sheet 1 has a table to put money into different months. Rows denote different amounts of money and columns denote months.
Sheet 2 has a huge table with months, dates, monetary values, quantities and information for all possible outcomes from sheet 1. The data there is fed by Sheet 1. If you select a month & put money amount in sheet 1, only that area is populated in this sheet, and everything else remains empty. What you select on sheet 1 is expanded upon in this sheet.
Sheet 3 is a month by month invoice. It needs a summary of information from Sheet 2. What I need is a formula for this one, where for example - Someone selected January in sheet 1 with 20 dollars, Sheet 2 will give an output for January for 20 dollars with more info.
I need that exact column data in sheet 3 under the month of January, and for all other months to show nothing. And if there is more than one selection in January, it should show that. But if someone selected January 20 dollars and September 20 dollars, only those 2 months should show data under them, and all other months should be empty
I have the entire month by month template of that piece, but I cannot seem to get that data properly from sheet 2 and make the rows empty or auto adjust their heights.
Any guidance and help will be appreciated. Thank you!