Results 1 to 10 of 10

Compare Two Sheets, Copy Data

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2021
    Location
    USA
    MS-Off Ver
    O365
    Posts
    51

    Compare Two Sheets, Copy Data

    Hello everyone. I have one for you. Attached are Alert.csv and tracking.xlsx. What I am trying to do are two things.

    1 - Alert.csv columns A (First Name), B (Last Name), C (User Email), D (Device Name) and U (OS Name) need to be compared to the data in Tracking.xlsx, and if the data of Alert columns A and B (or C if it's easier) is NOT present in Tracking, then I need Alert columns A, B, C, D and U copied to Tracking columns A, B, C, D and E on the first available row (currently 21).

    2 - In Alert.csv, columns F, G, H, I, J, K, L, M, N, O, S and T will contains values of either PASS, FAIL, WARNING or NA. If the values are either FAIL or WARNING I would like the title of that value listed in column X.
    For example - Row 16, Preston Soloff has either a warning or fail on: Password, Anti-Spyware, Disk Encryption. So in X16 I would like that cell to read "Password, Anti-Spyware, Disk Encryption".

    Is this possible? I would really appreciate any help!
    Last edited by mightymo77; 12-17-2021 at 02:05 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two sheets and copy data from sheet to another.
    By HXIO in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2018, 07:03 AM
  2. [SOLVED] Compare two rows of data in separate sheets then copy data
    By symaxf in forum Excel General
    Replies: 6
    Last Post: 07-30-2018, 09:41 PM
  3. [SOLVED] Compare names and copy data on two sheets
    By sprit36 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2017, 08:51 AM
  4. [SOLVED] Macro to compare data between sheets and copy/paste
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-24-2012, 05:46 PM
  5. compare data in 2 columns across 2 sheets and then copy data
    By CH53 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2011, 04:59 AM
  6. Compare 2 sheets & copy unmatched data below
    By tek9step in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2010, 10:57 AM
  7. Compare a value with value in other sheets and then COPY data into a sheet.
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2009, 03:05 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