HI there, this is my first question and I am hoping someone can help me please.
I am setting up a database in excel and I am an basic to intermediate user. But very quick to learn and know my way around a computer.
Anyway setting up a customer database in excel and I want to know how to auto populate data from my master datebase to automatically go into another spreadsheet (that is tabbed below). Eg. if I have a HOT BUYER column and I type Hot buyer in that column - can I auto populate all the information on that person (eg. name, address etc) into the HOT Buyer spreadsheet? Or do I have to cut and paste every time?
I will have multiple columns and spreadsheets that I will need to do this form
I have a fair idea of what you are attempting to do and no you won't have to cut and paste each time!
Basically you are wanting to take data from a "Master" work sheet and segregate that data into individual work sheets depending on a certain criteria in one of the columns in the "Master" sheet all in the same work book.
Please upload a sample of what you have in the work book that you are creating (be careful with any sensitive data). You can upload a sample by using a free file sharing site such as DropBox or ge.tt
You'll need to sign up with one of the file sharing sites (its free!), upload your sample to the file sharing site and, once uploaded, you will have the option of sharing your work book. Copy the link and paste it to this forum.