Hello again, I thank you for your help in leading me this far in the development of my spreadsheet, now I just have one more question about how to put the finishing touches on this project.
In the past few weeks, I have become more comfortable using VBA in the "View Code" menu on the WS tabs, and would like to utilize this tool to do a very specific function.
Here's the setup: When the user enters the workload for each employee and their respective projects into a grid setup in WS A (x rows of projects and y columns of employees), all of the data is transferred into a single column detailing each project and the hourly breakdown for each department, with today's date on top. This was a fairly simple, but time consuming setup, that I have already completed.
Now the hard part: Upon any change in the worksheet ("Private Sub Worksheet_Change()" ) I want the entire column of summarized hours and projects to automatically "paste special" into WS B into the proper column based upon the date.
Here is an example to clarify the situation: On 19 January 2004, the user enters the hours for all of the employees and projects into the grid; the data is then automatically transferred into the summary column. That column will be copied and pasted into WS B in the proper column based upon the date. Now, if the user re-enters some data the next day, 20 Jan. 2004, I want the VBA code to recognize that the week hasn't changed yet and paste over the column summary from the previous day. The next week will start at 12:00am on Monday morning. When the user goes to enter the summary for the next week, 26 January 2004, the code knows that the week has changed and will "paste special" the entire summary column from WS A into the next column in WS B. So, at the end of the year each week will be summarized into 52 columns and one can quickly see the utilization and project durations.
I'm not yet that proficient or comfortable in programming something that I feel is very sophisticated, but I have seen that many of you can do this fairly quickly. I appreciate any help that you can give me on this matter (tips, hints, or even a simple code that will do what I need it to do). I look forward to finishing this project, I just need a little more help.
Thanks again.
In the past few weeks, I have become more comfortable using VBA in the "View Code" menu on the WS tabs, and would like to utilize this tool to do a very specific function.
Here's the setup: When the user enters the workload for each employee and their respective projects into a grid setup in WS A (x rows of projects and y columns of employees), all of the data is transferred into a single column detailing each project and the hourly breakdown for each department, with today's date on top. This was a fairly simple, but time consuming setup, that I have already completed.
Now the hard part: Upon any change in the worksheet ("Private Sub Worksheet_Change()" ) I want the entire column of summarized hours and projects to automatically "paste special" into WS B into the proper column based upon the date.
Here is an example to clarify the situation: On 19 January 2004, the user enters the hours for all of the employees and projects into the grid; the data is then automatically transferred into the summary column. That column will be copied and pasted into WS B in the proper column based upon the date. Now, if the user re-enters some data the next day, 20 Jan. 2004, I want the VBA code to recognize that the week hasn't changed yet and paste over the column summary from the previous day. The next week will start at 12:00am on Monday morning. When the user goes to enter the summary for the next week, 26 January 2004, the code knows that the week has changed and will "paste special" the entire summary column from WS A into the next column in WS B. So, at the end of the year each week will be summarized into 52 columns and one can quickly see the utilization and project durations.
I'm not yet that proficient or comfortable in programming something that I feel is very sophisticated, but I have seen that many of you can do this fairly quickly. I appreciate any help that you can give me on this matter (tips, hints, or even a simple code that will do what I need it to do). I look forward to finishing this project, I just need a little more help.
Thanks again.
