jarvis1lsu
New Member
- Joined
- Mar 29, 2011
- Messages
- 1
I am currently running windows XP with excel 2003. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
This is the current problem that I am having. I have one spreadsheet that is a time card. It keeps track of regular hours, overtime hours, and callout hours. If you have overtime hours or callout hours, you have to click on the overtime/callout tab at the bottom to go to another spreadsheet to enter additional information (both spreadsheets are under the same filename. It has multiple tabs at the bottom). I use the word "additional" loosely because most of the data is on the first time card spreadsheet. Simply, you are just copying data over which is why I am trying to use formulas to help populate the information from the timecard spreadsheet to the overtime/callout spreadsheet. I have currently set up rows 5-13 with, =IF('Technician Timesheet'!E6>0,'Technician Timesheet'!K6,"") formulas in each cell with minor adjustments to each. If the callout hours (E6)>0, then put the description of the work (K6) from the time card sheet in the overtime/callouts sheet description cell. I did 7 for each day of the week. I also put, =IF('Technician Timesheet'!E6>0,'Technician Timesheet'!E6,"") formula under the hours cell on the overtime/callout sheet to put the hours (E6) from the timesheet. I did the same formula for the dates. I also repeated the above formulas 7 more times for overtime.<o></o>
<o></o>
The problem I am having is not every day has overtime or callouts. Also, not every pay period is the same as the previous pay period. This leads to the problem of having blank rows of data between call outs and overtime days. If Monday had either overtime or callouts and Wednesday had either overtime or callouts, but Tuesday had neither, the row allocated to Tuesday is left blank with data above and below. I used a VBA macro from the net that deleted blank rows and moved rows that were not blank up, but if a cell had a formula, it was considered not blank, even though no data was returned. Is there a way to move rows that returned data up and the rows that returned no data down with in a range (rows 5-34)? I still want the bottom of the overtime/callout sheet (rows 35-37) to stay untouched which has the totals. Is this possible and any help would be great.
jarvis
fficeffice" /><o></o><o
></o>This is the current problem that I am having. I have one spreadsheet that is a time card. It keeps track of regular hours, overtime hours, and callout hours. If you have overtime hours or callout hours, you have to click on the overtime/callout tab at the bottom to go to another spreadsheet to enter additional information (both spreadsheets are under the same filename. It has multiple tabs at the bottom). I use the word "additional" loosely because most of the data is on the first time card spreadsheet. Simply, you are just copying data over which is why I am trying to use formulas to help populate the information from the timecard spreadsheet to the overtime/callout spreadsheet. I have currently set up rows 5-13 with, =IF('Technician Timesheet'!E6>0,'Technician Timesheet'!K6,"") formulas in each cell with minor adjustments to each. If the callout hours (E6)>0, then put the description of the work (K6) from the time card sheet in the overtime/callouts sheet description cell. I did 7 for each day of the week. I also put, =IF('Technician Timesheet'!E6>0,'Technician Timesheet'!E6,"") formula under the hours cell on the overtime/callout sheet to put the hours (E6) from the timesheet. I did the same formula for the dates. I also repeated the above formulas 7 more times for overtime.<o
></o><o
></o>The problem I am having is not every day has overtime or callouts. Also, not every pay period is the same as the previous pay period. This leads to the problem of having blank rows of data between call outs and overtime days. If Monday had either overtime or callouts and Wednesday had either overtime or callouts, but Tuesday had neither, the row allocated to Tuesday is left blank with data above and below. I used a VBA macro from the net that deleted blank rows and moved rows that were not blank up, but if a cell had a formula, it was considered not blank, even though no data was returned. Is there a way to move rows that returned data up and the rows that returned no data down with in a range (rows 5-34)? I still want the bottom of the overtime/callout sheet (rows 35-37) to stay untouched which has the totals. Is this possible and any help would be great.
jarvis
