|I'm hoping to find an excel guru and I'm hoping to be able explain my situation.|
I have a workbook that keeps track of employee time and equipment used
There are several tabs along the bottom
The two tabs on the left, one is for employee information and one tab is for equipment information
In the Employee tab, there are formulas to calculate regular hour pay and overtime pay and there are "alerts" that when you enter a date that is a sunday, it automatically changes the pay fields to a red background fill color to notify the person inputting data that all time entered on that day is overtime.
It is very complex with numerous formulas and calculations and notifications.
There are drop down menu selections for the type of employee and for other selections to.
Also in the employee and equipment sheets are columns of data. These columns are represented as A-N and they refer to job sites that an employee would be at.
So, for an example, in the Employee tab, you type in Joe's name... and in Column A, (certain job location) you would type in the number of hours worked, overtime hours and subsistence pay. Those column's correspond with tabs along the bottom of the sheet name A to N... which would be the certain job location.
Therefore you could observe your employee in the employees tab and the job location information from the A-N tabs.
So, I've been asked to add some additional tabs... O,P,Q and R.
Adding the tabs was a sinche
Now in the employee's tab, I have to add some additional columns and they have to do the same thing that the existing columns do... like the same mathematical calculations and such.
I thought I could simply highlight the headers of an existing column and right click and select "copy", then go to the first blank column on the right and select paste.
Although I now have column's O,P,Q, and R, and I have corresponding tabs, when I type data into any of the new columns, I do not see any data in the corresponding tab
I really really need some help.