sunshinereel
New Member
- Joined
- Feb 10, 2022
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
- Mobile
Looking for a formula to auto populate amounts paid on a monthly basis listed in one worksheet(Data Dump worksheet) - Col B Date; Col D Vendor Name; Col J Amount paid into another worksheet with Col A listing each vendor and starting in Col H - Jan Date; Col I Jan Amount paid; Col J Feb Date; Col K Feb Amount paid and so on
There are roughly 200 rows of vendors and was looking for a formula to pull into so as to not individually enter each month's payment
Thoughts? Any suggestions are appreciated!
There are roughly 200 rows of vendors and was looking for a formula to pull into so as to not individually enter each month's payment
Thoughts? Any suggestions are appreciated!