Hello,

I have a spreadsheet where I have one tab linked to tab 2. Tab one has
a block of cells for each employee. The data being pulled is exported
into tab 2 from an external source and the number of rows for each
employee changes from month to month depending on how many days an
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 from
the external source, the first tab will automatically pull the correct
block of information or insert the breaks automatically between each
associate's information and shift the formulas in tab 1 to the
appropriate block. Is there a way to do this!!

Thanks!!

SteveG


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=274201

You can pull the data from tab2 into tab1 using the IF statement. Depending
on Tab2's name an example would be this.
If you want to pull column 1 data onto Tab1 an example IF statement would be
(Tab2's name is DATA):
=IF(DATA!A11=""," ",DATA!F11)
This says, pull the data in column A, cell 11 into whatever cell you put
this formula in. If there is anything in that cell it will be pulled over, if
there isn't anything then a blank space will be pulled over. You can do this
for each column, as long as you match up the correct columns and cell
numbers. Let me know if thats what you need....
Christen

"SteveG" wrote:


Hello,

I have a spreadsheet where I have one tab linked to tab 2. Tab one has
a block of cells for each employee. The data being pulled is exported
into tab 2 from an external source and the number of rows for each
employee changes from month to month depending on how many days an
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 from
the external source, the first tab will automatically pull the correct
block of information or insert the breaks automatically between each
associate's information and shift the formulas in tab 1 to the
appropriate block. Is there a way to do this!!

Thanks!!

SteveG


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=274201