Tracking # of people in the building, on the 1/2 hour

[GlennJ]

Hi Everyone,

I'm looking for a macro to run every 1/2 hour starting at 10am and the last entry at 2AM (33 entries per day). I have 2 sheets. I need the macro to copy the cell in Sheet1 (B2) to Sheet 2 and paste it into the next blank cell until that row is full and then start again on the next row (next day) until the month has ended.

I'm tracking the number of people that are in the building for each 1/2 hour of the day. Another macro changes the value in Sheet1 every time someone enters or exits the building.

Thank You for any help you can offer.

Glenn

	25
		Sheet1

	10:00	10:30	11:00	11:30	12:00
Sept 1	15	22	25	35	50
Sept 2	10	16	29	31	45
Sept 3	15	12	paste here
Sept 4
		Sheet2

 

[Misca]

May I suggest a simple improvement on your data sheet structure? You might want to use fewer columns in your database sheet. Things will be a lot easier in the long run if you had just three columns: One for date, one for time and the third one for number of people.

The current setup (fewer rows with tons of columns) may be easy to understand when you look at it but computers prefer more rows with less columns. From this setup it'll be easy to get to the user friendly multiple columns setup but not that easy to go the other way around.

The save code itself is really easy to come up with - especially with the suggested data structure - but I'm not that familiar with the automatic timer codes so I'd rather leave that part to those better than me.

 

[GlennJ]

Thanks Misca, I changed it to the way you said and I figured the VBA code I need.
Thanks for the help