VashTstmpe
New Member
- Joined
- Jan 19, 2024
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
I am not a programmer but it seems a VBS script could help me with do what i do everyday alot easier. Here is my scenario
I have attached two spreadsheets one i just called counts not the actual name of it and 01 - Januaray.xlsx. The data in counts Column A are peoples names that can be many and then there is a location number in column B and then Column C is the data that needs to be copied over to spreadsheet 01 - January. In the 01 - January there are tabs at the bottom for each day of the month but i will always be in the day that is being worked on. and the counts will always be the day that i am working on. So the data from Count.xls column C needs be copied over to 01 - January to the correct field that is associated to the person and the center number.
Sorry if this was confusing but hopefully the spreadsheets will help.
I have attached two spreadsheets one i just called counts not the actual name of it and 01 - Januaray.xlsx. The data in counts Column A are peoples names that can be many and then there is a location number in column B and then Column C is the data that needs to be copied over to spreadsheet 01 - January. In the 01 - January there are tabs at the bottom for each day of the month but i will always be in the day that is being worked on. and the counts will always be the day that i am working on. So the data from Count.xls column C needs be copied over to 01 - January to the correct field that is associated to the person and the center number.
Sorry if this was confusing but hopefully the spreadsheets will help.