S
SteveG
Hello,
I have a spreadsheet where I have one tab linked to tab 2. Tab one ha
a block of cells for each employee. The data being pulled is exporte
into tab 2 from an external source and the number of rows for eac
employee changes from month to month depending on how many days a
employee works.
Example:
Column 1 Column 2 Column 3 Column 4
Date Employee Staffed Time Time in Lunch
I am tryng to set it up so that when the data is pasted into tab 2 fro
the external source, the first tab will automatically pull the correc
block of information or insert the breaks automatically between eac
associate's information and shift the formulas in tab 1 to th
appropriate block. Is there a way to do this!!
Thanks!!
Steve
I have a spreadsheet where I have one tab linked to tab 2. Tab one ha
a block of cells for each employee. The data being pulled is exporte
into tab 2 from an external source and the number of rows for eac
employee changes from month to month depending on how many days a
employee works.
Example:
Column 1 Column 2 Column 3 Column 4
Date Employee Staffed Time Time in Lunch
I am tryng to set it up so that when the data is pasted into tab 2 fro
the external source, the first tab will automatically pull the correc
block of information or insert the breaks automatically between eac
associate's information and shift the formulas in tab 1 to th
appropriate block. Is there a way to do this!!
Thanks!!
Steve