Results 1 to 6 of 6

Macro to add items with value to another tab

Threaded View

  1. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Macro to add items with value to another tab

    I went with this macro assigned to the button:

    Option Explicit
    Public Sub AddItemsToList()
    
    Dim vC As Range
    Dim nR As Long
    
    nR = Worksheets("LIST").Cells(Worksheets("LIST").Rows.Count, "A").End(xlUp).Row + 1
    For Each vC In Range("E:E").SpecialCells(xlCellTypeConstants)
        With Worksheets("LIST").Cells(nR, "A")
            .Value = vC.Offset(0, -4).Value
            .Offset(0, 1).Value = vC.Value
        End With
        vC.Value = ""
        nR = nR + 1
    Next vC
    
    End Sub
    Also attached.

    WBD
    Attached Files Attached Files
    Office 365 on Windows 11, looking for rep!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to Copy Unique items i>e non duplicated items
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2022, 02:04 PM
  2. Macro to Match Items in Col C
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-27-2020, 12:20 PM
  3. [SOLVED] Macro to delete certain items then count remaining items #2
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-21-2019, 02:26 PM
  4. [SOLVED] Macro to delete certain items then count remaining items
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-14-2019, 03:20 PM
  5. [SOLVED] Macro to retain only certain items
    By flupsie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2017, 07:00 AM
  6. macro to filter all items in Autofilter except 2+ items
    By DanRiverBrew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2013, 09:15 PM
  7. Identify Items, Sort those Items, Copy the Items
    By a1981stingray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2010, 10:50 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