Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a series of data on a sheet called "DataEntry", on this sheets data is
entered for 4 shifts (Shift A, B, C, D) listed vertically in column A1:A3000. These values are a mix and not listed alphbetically (Example A, C, A, B, C, D, D, C, etc, etc) these go across the sheet 10 - 12 columns wide. Now, I have other worksheets which represent each of these shifts respectively; A-Shift, B-Shift, C-Shift, D-Shift. What I'd like to do is grab (if possible) any data for A shift on the "DataEntry" worksheet in column A1:A3000 and plug them unto the A-Shift worsheet chronologically entered without any blank line/records between them, since these would be have been a mix on the parent/source worksheet. Is this appraoch even possible? If so, How? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
transfer an excel work sheet to Paint | Excel Discussion (Misc queries) | |||
can I transfer data from sheet 1 to sheet2? | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |