+ Reply to Thread
Results 1 to 1 of 1

many actions in one macro: copy sheet "G" and paste "g_koond" no empty rows and add ID

  1. #1
    Registered User
    Join Date
    04-10-2020
    Location
    Estonia
    MS-Off Ver
    365
    Posts
    1

    many actions in one macro: copy sheet "G" and paste "g_koond" no empty rows and add ID

    Hello!

    First, sorry for bad english!

    I'am very new in macro world and I really need help.

    I have a document where I just cant get the macro correct.

    Sheet1 (Sheet "G" in my sample) I'm inserting information, and I need to copy paste it to sheet2 (sheet "g_koond" in my sample) - always at the bottom, by automatically inserting a new serial ID for each paste and loosing empty rows.
    Same time when I insert data to sheet1 I need to know (A2), what is the ID of the new paste that I am inserting (last ID + 1- so 1G; 2G; 3G etc).
    I have been struggling with this almost a week, and now I thought, maybe somebody can help me with this problem.
    Thank you for any help!

    Rein

    P.S. column "N" in picture at sheet2 is just a mistake. Please do'not include it to macro.
    Attached Images Attached Images
    Attached Files Attached Files

+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  3. Looping thru rows and copy cell values from "Inputs" sheet to "Output" sheet
    By hariexcel1987 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2015, 11:32 PM
  4. Replies: 2
    Last Post: 01-15-2015, 04:45 PM
  5. Short "Basic" Macro to copy and paste formulas "N" times.
    By gradyhawks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2014, 02:34 PM
  6. [SOLVED] Copy multiple rows that contain a certain "name" in column "A" then paste it into new work
    By rschlot2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2013, 02:25 PM
  7. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM

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