I was trying to copy data from another excel work book to new excel work book, but the new excel work book rows are merged 2 together , example : The names in the rows are merged with two rows ,
row number name
Its in the middle aligned after merge, but when I tried to copy the data from other work book using this formula :='[namelist.xlsx]Staff List'!C2 (Namelist is the workbook and Staff list is a Sheet name , row c2) , and when I drag down , its skipping one row due to merge issue (example: second row formula brings the value of C4 instead of C3)
How can I write a formula or VBA to paste the data while skipping one row...
Please help me guys !