Extend single dated segment of a worksheet to 30 days;

I have created a worksheet that allows me to enter timed data for a single day.  I want to extend that to include 30 days of data.  Using the same cell formatting with a new date for each section.  The B column will not change of course; and will be frozen for data entry. How do I do that?
VS-chart.xlsx
mikecox_Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
If I understood your question, you want to insert the block for each day for the month of first date you input in C2.

If so, please find the attached workbook and click on the Button Insert Blocks to get the desired output.

You only need to change the date in C2 and the code will add the blocks for that month.
VS-chart.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mikecox_Author Commented:
Great, that did the trick, I have the 30 days of blocks; which is just what I wanted, but how did you do it?

Where did "Insert Blocks" and "Clear blocks" come from?  

How would I create such an option in the future?  For example, I want to create another 30 series for October, on another worksheet.  I suppose I could copy this worksheet and just change the date.  But I want to understand the Blocks option.

I searched and found references to the option in XL but with references CAD.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
1) Open the workbook I uploaded with the codes.
2) Press Alt+F11 to open VBA editor.
3) You will see the codes which are assigned to the buttons.
4) If you don't see the code window, double click on Module1 to view the code.
5) On Module1, you will find two codes AddBlockForEachDay and ClearBlocks which are assigned to their respective buttons on the sheet.
6) To apply the same code to another sheet in the same workbook, just create a copy of this sheet along with the buttons, rename the new sheet and change the date in C2 with the first date of next month.

Hope that helps.
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
credit to @sktneer,

I have self developed this for fun, which enable the list of days to be copied to existing or on a new worksheet, with the option to select the Month of the list.

@mikecox_
you may adapt this when necessary.
VS-chart_b.xlsm
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Good variation Ryan.

With some more modification. :)
VS-chart_b.xlsm
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
@sktneer

coool cheers
mikecox_Author Commented:
Thanks for explaining the "trick" (-:  And for the twist Ryan.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.