+ Reply to Thread
Results 1 to 1 of 1

New records from multi sheets to one sheet

  1. #1
    Registered User
    Join Date
    03-11-2023
    Location
    GR
    MS-Off Ver
    MS Officce 2019 and 2016
    Posts
    8

    New records from multi sheets to one sheet

    When I start a recording in C8:E8 then the date and name of the windows user is entered in F8 & G8. Also in I8, the number of the registration is entered.
    Now if I make a change in E8, it changes I8 and a new record is made in the same line in cell H8 the new name of the windows user (it can be the same or another user).
    Also, the first record of time and user name together with the rest, I want it to be entered in the "UserNames(A)" sheet, but not only for the "DD" sheet, but I want it to apply to all green sheets and the records to be one below the other. Also copy cells A8 and C8 in the "UserNames(A)" sheet. Every time a change is made to E8, I8 is changed and entered in the "UserNames(A)" sheet. You mean that the record with the same number of cell A8 and C8 remain on the same line in the sheet "UserNames(A)".
    I want the same to be true for all reds. that is, to insert into UserNames(B). I have only made the green sheets.
    I am asking for your help so that I can continue with the red sheets and complete the project.

    It's also not just these green and red sheets. There are many more, just to be able to make the file smaller and put it here, I have deleted them.

    There is a vba code in the workbook and then a vba code in each sheet.

    Thank you in advance.
    Attached Files Attached Files
    Last edited by spmatrix; 11-20-2023 at 03:12 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. bringing info from multi sheets to one sheet
    By saser in forum Excel General
    Replies: 6
    Last Post: 11-14-2021, 07:41 AM
  2. Compare multi columns in 2 sheets and return records that dont match, eliminate duplicates
    By tkalinoski in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 10-08-2021, 12:59 PM
  3. [SOLVED] Multi Sheets all data to in one sheet
    By ronettes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2018, 02:01 AM
  4. [SOLVED] Specific unique data records on Sheet 1 needs sent to Sheets 2 or 3.
    By FonzAre138 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2016, 11:43 AM
  5. Compare 2 sheets and copy new records into result sheet
    By Chandrahaas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2014, 04:28 AM
  6. Replies: 4
    Last Post: 03-22-2011, 09:44 PM
  7. How to Coping one sheet to multi sheets?
    By ddtstartrex in forum Excel General
    Replies: 4
    Last Post: 01-01-2009, 02:59 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