0
Undo
Votes
Hi Extendoffice Friends!
Need your help.
I am working on a file wherein I need to copy a specific cell value, multiple times into another tab I am lost right now.
Here is what I am working on.
My tab named "Complex" have 21 rows. Column B on this tab was derived from the Source tab "A2"
For the next value of the source tab, A3 onwards, I will need to duplicate the 21 rows on the complex tab, A2:A22 and C2:C22 into the next black row after it.(A23 and C23 onwards)
This time, the value of B23 in the complex tab will be the value of A3 in the source tab.
The loop repeats until all the values in A of the source tab gets completed.
Nothing should be changed in the complex tab - but it will just be copied by the number of times thee values of A in the source tab.
I am working on thousands of values in the source tab. Any help will be appreciated.
Need your help.
I am working on a file wherein I need to copy a specific cell value, multiple times into another tab I am lost right now.
Here is what I am working on.
My tab named "Complex" have 21 rows. Column B on this tab was derived from the Source tab "A2"
For the next value of the source tab, A3 onwards, I will need to duplicate the 21 rows on the complex tab, A2:A22 and C2:C22 into the next black row after it.(A23 and C23 onwards)
This time, the value of B23 in the complex tab will be the value of A3 in the source tab.
The loop repeats until all the values in A of the source tab gets completed.
Nothing should be changed in the complex tab - but it will just be copied by the number of times thee values of A in the source tab.
I am working on thousands of values in the source tab. Any help will be appreciated.
There are no replies made for this post yet.