kevinc1973
New Member
- Joined
- Jun 20, 2019
- Messages
- 22
Hello everyone,
I was wondering if anyone has an idea on how to write to a sheet by date? I have 6 rows of data per day and they are timestamped staring at midnight - 20:00 every four hours, and i use 6 different user forms. Is there a way to have the date in textbox1 7/15/2019 and only take the day "15" go to specific rows on the sheet? If i could do this I would be able to write over the data if i was to make a mistake and then go to 6 different rows on the next day without writing over the previous day's data. The data also gets saved at the end of each month and then deleted for a new month. If not i could make 31 different user forms and name them with the round name and the days date for ex: "inround080015" the last 2 numbers would be the day of the month which it could get on the main sheet where the command button is to open the userform, just dont know how to code that to open. I now have it just writing to the next available row but people keep entering the stuff 2 or 3 times and it screws up my other sheets for calculations.
Sorry for the confusion Thanks
I was wondering if anyone has an idea on how to write to a sheet by date? I have 6 rows of data per day and they are timestamped staring at midnight - 20:00 every four hours, and i use 6 different user forms. Is there a way to have the date in textbox1 7/15/2019 and only take the day "15" go to specific rows on the sheet? If i could do this I would be able to write over the data if i was to make a mistake and then go to 6 different rows on the next day without writing over the previous day's data. The data also gets saved at the end of each month and then deleted for a new month. If not i could make 31 different user forms and name them with the round name and the days date for ex: "inround080015" the last 2 numbers would be the day of the month which it could get on the main sheet where the command button is to open the userform, just dont know how to code that to open. I now have it just writing to the next available row but people keep entering the stuff 2 or 3 times and it screws up my other sheets for calculations.
Sorry for the confusion Thanks