How to Paste Data in nth Cell every time from One Cell only.
I am Trying to Create One sheet where Only One Cell (Column A1) will be updating and i need to store data of every entry(A1) in a different workbook.
Column A1 will have Ram/Shyam/Sita either of them but another workbook will consolidate all 3 names.A1 Ram, A2 Shyam, A3 Sita
I am Trying to Create One sheet where Only One Cell (Column A1) will be updating and i need to store data of every entry(A1) in a different workbook.
Column A1 will have Ram/Shyam/Sita either of them but another workbook will consolidate all 3 names.A1 Ram, A2 Shyam, A3 Sita