Pull information from one sheet to another
Closed
clintcollins920
Blocked Profile - May 24, 2017 at 04:04 PM
- Posts
- 1
- Registration date
- Wednesday May 24, 2017
- Status
- Member
- Last seen
- May 24, 2017
Blocked Profile - May 24, 2017 at 04:04 PM
Related:
- Pull information from one sheet to another
- How to automatically pull data from another sheet in excel - Guide
- Excel pull data from another sheet based on criteria ✓ - Forum - Excel
- Copy rows based on a condition ✓ - Forum - Excel
- How to pull data from a master sheet in excel - Guide
- Comparing Rows on two worksheets and pull data into a new sheet ✓ - Forum - Excel
1 reply
You are trying to use a spreadsheet as a database. A spreadsheet is for calculating, not for storing.
Start a new Access db, and create some tables:
COUNSLER -this is where all of the counselor stuff is stored, that is counselor specific (phone, address, office, NO CUSTOMER DATA). Make certain you give each counselor a unique number.
CLIENTS - This is the clients sheet. Make certain you give all clients a unique number.
Appointments - This is where you put the date and time of the appointment, and the unique counselor number, and the unique client number, and maybe a short description of what happened.
Now you can link it all together, by reporting on the appointments table, linking the appointments to the clients and the counselors!
It sounds like alot of work, but in the long run, it scales. EXCEL solutions do not scale, and if we make an excel solution, you will continually have to alter the formulas as your list grows!
Let me know if you need any help.
It's kind of fun to do the impossible! -Walter Elias Disney
Start a new Access db, and create some tables:
COUNSLER -this is where all of the counselor stuff is stored, that is counselor specific (phone, address, office, NO CUSTOMER DATA). Make certain you give each counselor a unique number.
CLIENTS - This is the clients sheet. Make certain you give all clients a unique number.
Appointments - This is where you put the date and time of the appointment, and the unique counselor number, and the unique client number, and maybe a short description of what happened.
Now you can link it all together, by reporting on the appointments table, linking the appointments to the clients and the counselors!
It sounds like alot of work, but in the long run, it scales. EXCEL solutions do not scale, and if we make an excel solution, you will continually have to alter the formulas as your list grows!
Let me know if you need any help.
It's kind of fun to do the impossible! -Walter Elias Disney