How to autopopulate columns from multiple sheets
I update this table every week from a set list on a website. I then have to fill in the missing columns from previous weeks. The data will repeat inconsistently, sometimes from the previous week, others from a few weeks, and some will repeat multiple times. I need to prioritize filling data in from the most recent weeks.
The main information that I want to look for is the address, but I also need the MLS# to match as that can update randomly as well, but that is easy to check in the listing link so not as important.
My current solution is to just search the workbook for the address and manually copy paste from the most recent week, but that is time consuming as I can have over 100 rows to sift through.
Is there a way to autopopulate these columns, searching the workbook, but prioritizing the most recent sheet data?
[link] [comments]
Want to read more?
Check out the full article on the original site