Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 04, 04:01 PM
SteveG
 
Posts: n/a
Default Data from one tab to another


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


  #2   Report Post  
Old November 1st 04, 06:00 PM
Christen
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 05:15 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017