+ Reply to Thread
Results 1 to 2 of 2

Macro for Copying Specific data from a table to a new Row

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Macro for Copying Specific data from a table to a new Row

    I've got a table that holds raw data of 3 pieces.
    Name, Years of Service, Annual Salary.
    The rest is locked protected formulas that doesn't need any adjustment

    I'm attempting to make a clickable button that can retrieve that information and paste it to a new; on same sheet below it or on a new sheet within the same workbook.
    I can build something that will paste to a static location like B13, C13, D13, but if i use the button again the new information re-writes the old. Would need something maybe like an If Range B13value isn't blank. paste to B14, C14, D14. so it will save the name and entry results in a list.

    Im not very good at this @_@

    Dave - 109$
    Jimmy - 112 $
    Steve - 327 $

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Macro for Copying Specific data from a table to a new Row

    quoe
    If Range B13value isn't blank. paste to B14, C14, D14.
    unquote
    if there is no blank row
    range("B1").end(xldown).offset(1,0)
    will take you to the row next to last entered cell in column B
    can you use this idea?
    I am not an expert. better solutions may be available
    [email protected]

+ 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. Macro to copy specific data to specific columns from a pivot table
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2012, 07:24 PM
  2. VBA Macro Help: Copying and pasting data that is date specific
    By bleedUTorange in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-03-2011, 02:00 PM
  3. Macro for copying data from pivot table to other workbook
    By ronlau123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2011, 08:02 AM
  4. Replies: 0
    Last Post: 05-06-2006, 01:10 PM
  5. [SOLVED] Macro Help - copying specific data
    By Dave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2005, 03:06 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