Pasting data in every other rows

Dear All,

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
2 Steve
3

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 !

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )