Copy data from one spreadsheet to another with certain criteria it meets using VBS

VashTstmpe

New Member
Joined
Jan 19, 2024
Messages
1
Office Version
  1. 2019
Platform
  1. 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.
 

Attachments

  • 01 - January3.JPG
    01 - January3.JPG
    135.8 KB · Views: 7
  • 01 - January.JPG
    01 - January.JPG
    144.1 KB · Views: 7
  • 01 - January2.JPG
    01 - January2.JPG
    146.6 KB · Views: 6
  • 01 - January3.JPG
    01 - January3.JPG
    135.8 KB · Views: 7
  • Count1.JPG
    Count1.JPG
    80.2 KB · Views: 7
  • Count2.JPG
    Count2.JPG
    84.9 KB · Views: 7

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top