+ Reply to Thread
Results 1 to 2 of 2

Pasting data in every other rows

  1. #1
    Registered User
    Join Date
    02-13-2017
    Location
    uk
    MS-Off Ver
    365
    Posts
    1

    Post 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 !
    Last edited by sathmaha; 02-14-2017 at 04:30 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,311

    Re: Urgent Help needed

    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 )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Urgent help needed!!!
    By thcguy12 in forum Excel General
    Replies: 5
    Last Post: 03-24-2016, 11:21 PM
  2. URGENT help needed
    By qwerty11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2008, 12:46 AM
  3. Urgent help needed
    By deano6410 in forum Excel General
    Replies: 2
    Last Post: 09-21-2006, 04:16 PM
  4. Help Needed Urgent
    By BiggieD in forum Excel General
    Replies: 7
    Last Post: 04-19-2006, 12:04 PM
  5. Urgent Help needed
    By Brento in forum Excel General
    Replies: 0
    Last Post: 02-09-2006, 05:10 PM
  6. Urgent help needed
    By ef03thse in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2005, 05:56 PM
  7. Urgent Help Needed.
    By wwfc_barmy_army in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1