Results 1 to 10 of 26

Thread: Misc. Leonardo1234 rider@1234 vixer. Highlighting. Simple Early stuff. Avinash Introduction

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #14
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    Copy Cell Based On Column Position Of Highlighted Cell In Matched Row

    all files are located in a same place
    vba code will be placed in a macro.xlsm
    my first file name is 1.xlsx
    my second file name is 2.xlsx
    open both the files
    in 1.xlsx column A consist of stock name and 1.xlsx has headers in the first row
    In 2.xlsx column B consist of stock name and 2.xlsx has headers in the first row
    see the pic which i attached
    now what i need match column A stock name of 1.xlsx with column B of 2. xlsx and if it matches then copy the yellow highlighted colured cell data in that row of 1.xlsx and paste it to column L OF 2.xlsx
    save and close both the file after doing the process
    So plz help me sir in solving this problem sir
    Attached Images Attached Images
    • File Type: jpg 2.jpg (20.4 KB, 9 views)
    • File Type: png 1.PNG (7.1 KB, 9 views)
    Last edited by DocAElstein; 03-06-2020 at 11:15 PM.

Similar Threads

  1. Class Stuff: VBA Custom Classes & Objects, Class Modules
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 29
    Last Post: 06-02-2024, 01:49 PM
  2. Replies: 9
    Last Post: 05-13-2021, 02:31 PM
  3. Replies: 2
    Last Post: 06-23-2019, 03:30 PM
  4. VBA Range.Sort with arrays. Alternative for simple use.
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 24
    Last Post: 04-22-2019, 12:31 PM
  5. Free And Simple Excel Based Gantt Chart
    By Excel Fox in forum Download Center
    Replies: 0
    Last Post: 05-02-2013, 03:16 PM

Tags for this Thread

Posting Permissions

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