Transfer From one to another sheet
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?
|