I need to copy cells that have been filled from one sheet to other sheet.
The cells to be copied on sheet1 are B7:21 & E7:11 & H7:16. They need to be paste on sheet2 all in one column A1 with NO blank spaces. (see file)
Here is the hard part:
Sheet1 columns will be B E H K N Q T W. These columns will change on how many cells are filled with serial numbers, I still need to copy and all of them on sheet2 in column A with no blank spaces.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.