W
waltzm
Hi
Here is my problem. I am trying to use a formula to extract data from
one worksheet to another (within a workbook).
The data is like this: the source worksheet has the cells like C1, C5,
C9, C13, ... (basically add 4 to the previous cell number) which will
be pasted as concurrent cells in the new worksheet (i.e. as A1, A2, A3,
....). I am avoiding doing this manually by copying each cell content as
my data is too big to allow this.
Can anyone help plis.
Regards
NB: I can post my file as well if that would help, in which I can be
more specific in case this is not clear.
Here is my problem. I am trying to use a formula to extract data from
one worksheet to another (within a workbook).
The data is like this: the source worksheet has the cells like C1, C5,
C9, C13, ... (basically add 4 to the previous cell number) which will
be pasted as concurrent cells in the new worksheet (i.e. as A1, A2, A3,
....). I am avoiding doing this manually by copying each cell content as
my data is too big to allow this.
Can anyone help plis.
Regards
NB: I can post my file as well if that would help, in which I can be
more specific in case this is not clear.