I know exactly what I want i just need someone to help me out with the VBA's please I am trying to get Timesheets to auto-populate based on information on a master sheet in the workbook.
I know exactly what I want i just need someone to help me out with the VBA's please I am trying to get Timesheets to auto-populate based on information on a master sheet in the workbook.
Last edited by mommy2aboss; 01-30-2018 at 04:00 PM.
But we don't. In fact, we are clueless.I know exactly what I want
We build things here. I know you can't drive down the street see the structures, but we build things in the same process you do. We start by developing a plan from the given details. If a detail is missing, we can't make good plans.
At this point in our conversation. we're at the point you would be if someone came to you and said, "We want a switching station at First and Main. When can you start and How Much?"
BTW, I had 20+ years in construction, Residential, Commercial, and mostly Civil. I got into VBA as a means to automate my own office. My last Employee job was Project Foreman for Swinerton and Walberg, NKA Swinerton Builders. My current office is just 180m west of your Corp HQ.
May I suggest that you edit your post to remove that workbook and replace it with one that has all personal and proprietary information R&R'ed. Either just delete it or overwrite all instances with "lorem ipsum" or "***xx."
Be aware that all VBA must reside in *.xlsm and *.xlsb workbooks, NOT *.xlsx files
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Thanks I appreciate your feedback. I am new to this and know this is something fairly simple in the VBA world I had a workbook done previously by someone else and it took them about a whole 20 minutes. I know it is not difficult once I am able to explain it. I need a workbook to generate timesheets based off of information on a master sheet.
Create a Master sheet with some dummy information, then create a Timesheet based on that information. Be sure we can know where each particular bit of data on the timesheet came from on the Master sheet. Save that workbook as a "Macro Enabled Workbook."
Thank you for deleting that first attachment.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
"Good night, Gracie"
See you tomorrow.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Hi mommy2aboss, welcome to the forum.
As SamT says, we need information before we can do anything.
YOU may know exactly what you want, but at this moment all we know is that you
From this information we could present you with loads of different workbooks, but it's a good guess that not one would be suitable to your needs.need a workbook to generate timesheets based off of information on a master sheet.
Think of asking for a new outfit for a special occasion, would you be so vague?
I like this:
It's like me saying "I am new to construction and my home extension took someone 3 weeks to build, so I know you can build me an effluent plant for the City quickly, go ahead please"I am new to this and know this is something fairly simple in the VBA world I had a workbook done previously by someone else and it took them about a whole 20 minutes.
Conclusion: Please, again with what SamT is saying, provide detailed information of what you require.
Cheers
Paul Ked
Semper in excretia sumus; solum profundum variat.