I need help with the following.
I have a set of values on rows in worksheet 1 that are sequential (i.e. B1, B2, B3….)
I need to copy those values into a different worksheet in non-sequential order (6 columns apart with thins in between). Ideally what I need is a formula that helps expedite because there are 12 rows and 50 columns that I need to copy. Also, I need the value of sheet one that when it it changed it is also changed in sheet 2.
To be exact what I need is the following.
I have values in worksheet 1 in rows E9, E10, E11 etc.
Thos values have to be imported into worksheet to as follows
E9 goes to G6
E10 goes to N6
E11 goes to U6
Etc.
If someone can help would appreciate it.
Thanks