ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Data from one tab to another (https://www.excelbanter.com/excel-worksheet-functions/5438-data-one-tab-another.html)

SteveG

Data from one tab to another
 

Thanks for the reply Christen. I wound up using a VLOOKUP which seems
to pull the information correctly. The only problem is that it still
involves manually inserting rows between the different blocks(employee
specific) of data from tab 2 so that the spacing matches the spacing on
tab 1. I need that so that formulas I am using in tab 1 that reference
the data work correctly. Not sure if this can be automated in the
formula or not.

Thanks again.

Steve


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



All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com