Excel Marcos for lookup and entry
Closed
Peter3540
Blocked Profile - Aug 18, 2015 at 04:56 PM
- Posts
- 1
- Registration date
- Tuesday August 18, 2015
- Status
- Member
- Last seen
- August 18, 2015
Blocked Profile - Aug 18, 2015 at 04:56 PM
Related:
- Excel Marcos for lookup and entry
- Excel - macro to lookup cell and add new row - How-To - Excel
- VBA Copy sheet to new Excel File + automated manual data entry ✓ - Forum - Excel
- Lookup same Entry A1 in 2 worksheet & return B1 from 2nd w/sheet ✓ - Forum - Excel
- Excel - Counting number of days between two entries - How-To - Excel
- Complicated Lookup in Excel - How-To - Excel
1 reply
Yes, all of that is possible. Please understand we are volunteers that work on our own free time. We generally will help when stuck with codes, and we DO NOT provide a turn key solution.
Once again, if you get stuck with something, let us know and we can work past it. I would suggest that if you do not have any programming experience with excel, you record a macro to do what you want it to do, and reverse engineer it to make changes. Make a Macro and post it, then we can help.
Have FUN!
P.S. You really need a "Truck" Table in a database, to be honest! Build the table to have Truck-Item-Qty. Then you can run a report against all entries of "Truck 1", total each item into a report and get the number of items shipped by each truck. This solution would leverage the already built in functions of the database, and you would have the report writer that will format your reports nicely, quickly! Just a thought!
Once again, if you get stuck with something, let us know and we can work past it. I would suggest that if you do not have any programming experience with excel, you record a macro to do what you want it to do, and reverse engineer it to make changes. Make a Macro and post it, then we can help.
Have FUN!
P.S. You really need a "Truck" Table in a database, to be honest! Build the table to have Truck-Item-Qty. Then you can run a report against all entries of "Truck 1", total each item into a report and get the number of items shipped by each truck. This solution would leverage the already built in functions of the database, and you would have the report writer that will format your reports nicely, quickly! Just a thought!