Results 1 to 2 of 2

Function to Paste data to next empty row A column

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2020
    Location
    Washington State
    MS-Off Ver
    2008
    Posts
    2

    Question Function to Paste data to next empty row A column

    I am trying to figure out a code to copy and paste items to the next empty row on the summary page.

    Basically, what I want the code to do is:

    Select.Sheet2 Copy A2:end of RowA items and paste it on Summary first empty spot (A2)
    Select.Sheet3 Copy A2:end of RowA Paste on next empty Spot on Summary Page in Row "A"
    Select.Sheet4 Copy A2:end of RowA Paste on next empty spot on Summary Page in Row "A"

    This is obviously just an example workbook the sheets that I deal with are hundreds if not a couple thousand-line items.
    Not all the Rows have the same number of items on them so I cannot just post paste specific cells.
    Thank you for your time!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy data and paste to last empty column
    By hanif in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-12-2016, 10:08 AM
  2. [SOLVED] Find first empty column on row 1, paste data from listbox
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:56 AM
  3. Copy data and paste to another column incrementing that column to next empty cell
    By edens2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2015, 11:43 AM
  4. copy and paste data in another column in next empty cell
    By dilippyare in forum Excel General
    Replies: 3
    Last Post: 11-24-2014, 11:11 AM
  5. [SOLVED] Copy all cells in column that contain data & paste to first empty row of another column.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2014, 08:45 AM
  6. Copy and paste data if row in Column N is empty.
    By Hopper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2009, 03:25 PM
  7. Editting Macro to Select Last Empty Column to Paste Data
    By Zaraf in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-05-2008, 11:40 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