Good morning to everyone,
I hope to be clear enough as English it's not my mother tongue.
Here is my problem:
I'd like to copy data from various cell placed on the same lime but at a, fixed, different row position, without having to tape it manually.
I had a look on the net but between my inexperience and the differences in language (my excel is in localized in Italian), I'm having some rough time figuring it out!
This is what I would like to do:
copy Value from =Sheet1!A:10 - =Sheet1!E:10 - =Sheet1!J:10 - =Sheet1!O:10 (from every 5th row in Sheet1 for couple 100th times)
to Sheet2 A:10 - B:10 - C:10 - D:10 (filling every cell on a fixed line in Sheet2).
Like all newbies i tried writing down manually, couple of times, the cells from which the data should be taken and then i tried to drag hoping it would recognize the pattern: naturally it doesn't work.
If I input the first 2 or 3 (=Sheet1!A:10 in A:10, =Sheet1!E:10 in B:10, =Sheet1!J:10 in C:10) and then drag it goes with the very next one following (=Sheet1!K:10).
Please point me to something that can help me sort this out!
Thanks.
Bookmarks