+ Reply to Thread
Results 1 to 3 of 3

Match data between sheet & pasting the output by adding +1

  1. #1
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Match data between sheet & pasting the output by adding +1

    Hi,
    I am looking for a macro that will do the things mentioned below

    If column E of sheet3 of 3.xlsm matches with sheet4 of Column B of 10.xlsx then match the same with column B of sheet1 of 3.xlsm & if matches then put the numerical data in series by vba in sheet1 of 3.xlsm

    Macro will be placed in 3.xlsm file


    Thnx Alot



    Current problem is slightly similar to the below link so i shared it
    https://www.excelforum.com/excel-pro...ml#post5364093
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,284

    Re: Match data between sheet & pasting the output by adding +1

    then put the numerical data in series by vba in sheet1 of 3.xlsm
    What does this mean?
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Re: Match data between sheet & pasting the output by adding +1

    Please Login or Register  to view this content.
    In this macro see how we are increasing the numerical data in series by vba

    plz see this line
    Please Login or Register  to view this content.


    https://excelfox.com/forum/showthrea...4879#post14879
    I have posted this question to excelfox also
    Last edited by Zaeguzah; 09-03-2020 at 04:02 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] 2 Sheets data combined into output sheet with match 1 field common
    By AaruJaan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-24-2019, 03:00 PM
  2. [SOLVED] Macro that pastes data, how can I sort after pasting + format it to match older sheet data
    By stein7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2019, 07:20 PM
  3. [SOLVED] Problem on getting ID to match another sheet and output value
    By zackdy in forum Excel Formulas & Functions
    Replies: 36
    Last Post: 11-25-2013, 01:15 AM
  4. [SOLVED] Pasting values from one sheet to another and continue adding it
    By Kiran Mambi in forum Excel General
    Replies: 3
    Last Post: 11-09-2013, 06:05 AM
  5. Adding Summary vs pasting To Each Page and Then Creating Overall Sheet
    By Greggatm in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-10-2012, 08:04 PM
  6. [SOLVED] pasting array output to sheet
    By Pradip Jain in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-19-2005, 12:06 PM

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