Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |