ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   getting information from several columns (https://www.excelbanter.com/excel-worksheet-functions/157302-getting-information-several-columns.html)

tach

getting information from several columns
 
I have data that is stored on one workbook that entails information from
different shifts. ie. days1,2, swings 1, and graves 1, 2. The info is
organized by date and each shift in columns under each shift.

What I need to do is to copy all the information just for each shift into a
new worksheet. The worksheets are identical. I need to separate out each
shifts information and was wondering what is the easiest way to do it. I've
tried linking each column, but it won't do multiple columns since they are
spaced out. PLEASE HELP!!!


All times are GMT +1. The time now is 03:56 AM.

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