Excel or VBA formula to auto populate rows based on values

amitojsd

New Member
Joined
Jan 16, 2025
Messages
3
Office Version
  1. 365
Platform
  1. Windows
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!
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,226,113
Messages
6,189,046
Members
453,522
Latest member
Seeker2025

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top