Hello and good day
Need help with trying to get infomation into Sheet 1 from Sheet 2.
Sheet 2 data as follows
Cell A1 - 100
Cell B1 - 100
Cell C1 - 200
Cell D1 - 200
Cell E1 - 300
Cell F1 - 300
I want to bring into Sheet 1 data from Sheet 2 as follows:
Sheet 1 Cell A1 - 100 (corresponding to Sheet2 Cell A1)
Sheet 1 Cell A2 - 200 (corresponding to Sheet2 Cell C1)
Sheet 1 Cell A3 - 300 (corresponding to Sheet2 Cell E1)
and so on
Basically skipping the identical information from Sheet 2 cells B1,D1 & F1.. and so on
Can you help please?
Bookmarks