A person in another forum i dont remember which one helped write this code for me.
The code is written as such
The two files will be in the same folder and the Pastedatahere.xlsx file has to be open.
Originally i was only doing this a month a time but i am being requested to go back years.
So i have attatched the file Pastedatahere.xlsx and the destination file Location.xlsx
What i am asking if it can be done is for the data in Pastedatahere.xslx
put the data from it to Location.xlsx in the correct month, day and hour
Information on spreadsheets listed below
From Pastedatahere columns
A = Location
B = Day
C = Hour of day
D = Counts from that day
E = Month
From Location.xlsx.
Top row is day
Column A is Hours
And the tabs along the bottom of course are months
The outcome should move the data from Pastedatahere.xslx and put the data in the correct month tab
the correct day and the correct hour. i am sorry i am asking so much i am not a programmer at all
but have been tasked to get this information.
Thanks for any assistance. I know excel decent but not VBS at all. Working on learning it through what i have been shown and through the help wizard.
Bookmarks