Moving data to multiple sheets
Closed
mingalls1
Posts
1
Registration date
Thursday March 22, 2018
Status
Member
Last seen
March 22, 2018
-
Mar 22, 2018 at 03:09 PM
Blocked Profile - Mar 22, 2018 at 03:46 PM
Blocked Profile - Mar 22, 2018 at 03:46 PM
Related:
- Moving data to multiple sheets
- Sheets right to left - Guide
- Tmobile data check - Guide
- How to insert picture in word without moving text - Guide
- How to delete multiple files on mac - Guide
- How to lasso multiple objects in photoshop - Guide
1 response
OK, well, if you are having an issue making Excel code changes, learn something new and USE A DATABASE for what you are trying to accomplish. Spreadsheets are for calculations, not for storing values!
Get open office, or Microsoft ACCESS.
Make a table with columns. The columns are stuff like, date, time, and lets say who, and what.
So know you have a table with:
Date----------Time----------Who---------What--------
Now, you make a form, and link the Text boxs to the table columns. When you submit the form, you get the following:
Date----------Time----------Who---------What--------
3-22-2018--15:43--------Tech_A-----"fixed Washing Machine"
Now, you can write a report based on what date, what technician, or what they did, all without moving a thing, or writing code!!!
If you insist on using Excel, take a look here, and see if this helps:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
Let us know if you need help!
Get open office, or Microsoft ACCESS.
Make a table with columns. The columns are stuff like, date, time, and lets say who, and what.
So know you have a table with:
Date----------Time----------Who---------What--------
Now, you make a form, and link the Text boxs to the table columns. When you submit the form, you get the following:
Date----------Time----------Who---------What--------
3-22-2018--15:43--------Tech_A-----"fixed Washing Machine"
Now, you can write a report based on what date, what technician, or what they did, all without moving a thing, or writing code!!!
If you insist on using Excel, take a look here, and see if this helps:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
Let us know if you need help!
