+ Reply to Thread
Results 1 to 2 of 2

Macro copying number to the wrong column. Can you help me fix it?

  1. #1
    Registered User
    Join Date
    07-20-2015
    Location
    NYC
    MS-Off Ver
    2010
    Posts
    70

    Exclamation Macro copying number to the wrong column. Can you help me fix it?

    Hi,
    I was wondering if someone can help me.
    At the moment the most of the macros on this spreadsheet are working fine.
    However, when I filter the Revenue Report tab (yellow tab) by confirmed, and then go to the black tab (invoice audit) and press the copy from yellow tab button, it copies most of the data correctly.
    However there is something its doing incorrectly.
    One of the columns thats copying over, is copying it incorrectly. Here's what it should do...
    I need that whatever is in column J on the yellow tab (Revenue Report), to copy to column I on the black tab (invoice audit).
    Can you please help?
    Thank you in advance.
    Cele

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro copying number to the wrong column. Can you help me fix it?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Wrong number of Arguments error on macro - help!
    By KarlaB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2015, 01:30 PM
  2. [SOLVED] Macro - Copying undefined number of rows in one column
    By Rogy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-16-2015, 08:15 AM
  3. Replies: 2
    Last Post: 04-11-2014, 12:18 PM
  4. [SOLVED] Copying to wrong Column
    By bodwhat in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-24-2013, 01:28 PM
  5. Replies: 3
    Last Post: 04-10-2013, 06:33 AM
  6. Macro copying and pasting "wrong" columns with AutoFilter
    By MattWilson79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2012, 12:33 PM
  7. Macro - wrong column reference
    By chemoul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2012, 11:22 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