• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is this possible?

E

elsmith9035768

Member
I am in real estate and want to create a workbook and was wondering if this is possible. I download a .csv file from the MLS service and copy it into one sheet named MLS Download. I will have a few other sheets in the workbook (Sheet1, Sheet 2…). I want to have data moved from the MLS Download sheet to Sheet1, Sheet 2… based on different data restrictions that will be outlined on each sheet.

I want to set up a table of restrictions (sales price, sales date, bath count, view, square foot…). The table will be the same on each sheet but the restrictions will change. One sheet will restrict the data moved from MLS Download based on square foot and sales date, another sheet will restrict the data to be moved over by sales price, age, and bath count...

So, based on the restrictions for Sheet 1, Sheet 1 will have data moved from MLS Download to Sheet 1 based on bedroom count, square feet, and sales price.

Based on the restrictions for Sheet 2, Sheet 2 will have data moved from MLS Download to Sheet 2 based on bath count and sales date.

And so on.

I am new to Excel and was not sure if a workbook could be programed where I merge one file onto a workbook and then have data automatically moved to other worksheets based on different restrictions.

Also, can I setup a permanent sort/filter for each worksheet in a workbook so I don’t have to resort/refilter every time I use a workbook template for a new file?

__________________________________________________________________
Mod edit : thread moved to appropriate forum !
​
 

All you can do manually can be automated !

So just activate Macro Recorder and operate :
you will get your own free base of code …
​
 
Many things are possible.
As Tip: Upload a Sample File to get a quicker response
... with wanted layouts ... and so on.
 
PowerQuery would be ideal for this type of operation. But can easily be done through Advanced Filter, MS Query as well.

PowerQuery will not need any VBA code. Just Formula, Named Range and data connection.

Advanced Filter and MS Query will need relatively simple code.

Some tutorials.
PowerQuery with Dynamic Parameter
(You can set up static filter, if parameter doesn't change for each sheet)
https://blog.oraylis.de/2013/05/using-dynamic-parameter-values-in-power-query-queries/

Advanced Filter
http://www.contextures.com/xladvfilter01.html

MS Query
http://www.exceluser.com/formulas/msquery-excel-relational-data.htm
 
You must log in or register to reply here.
Back
Top