View Poll Results: hello all

Voters
0. This poll is closed
  • satisfied

    0 0%
  • unsatisfied

    0 0%
+ Reply to Thread
Results 1 to 1 of 1

copying specific range from one workbook to another in specific range based on condition

  1. #1
    Registered User
    Join Date
    11-13-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    1

    copying specific range from one workbook to another in specific range based on condition

    i just need to add a condition that in case if O2=O1 then copy range F2:L2 of book2 in B14:H14 in the same invoice(book1). keep coping downwards in book1 till the invoice no. changes in book2. and when it change, it first save the running invoice, clear all cells and start coping data of second invoice. it will be appreciated if you solve my problem.

    right now it can transfer only a single row, not multiple and only when invoice nos. are different.

    their should be update button that updates those invoices that already have been saved. so, please help me.

    Thanks in advance!!!
    Attached Files Attached Files
    Last edited by ankitgoyalhsr; 05-16-2015 at 04:01 AM.

+ 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. [SOLVED] Trying to move specific range to a specific sheet based on data in certain column
    By cain2011 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-01-2013, 08:09 AM
  2. Copying a range from Wks A to a specific range in Wks B into subseq blank rows in Wks B
    By Tanner2004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2013, 03:29 PM
  3. Transfer data to specific range based on condition
    By khatibcell in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-16-2013, 05:46 AM
  4. [SOLVED] VBA Question- copying specific range if condition is met
    By dnblnd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-09-2013, 12:03 PM
  5. HELP with copying/pasting specific range into different workbook
    By wojizzle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2012, 08:29 AM

Tags for this Thread

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