+ Reply to Thread
Results 1 to 4 of 4

Problem with copy data from "sales" sheet to each customer sheeet

  1. #1
    Registered User
    Join Date
    01-13-2013
    Location
    Warwick, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Problem with copy data from "sales" sheet to each customer sheeet

    What is wrong with this code please?

    comes up with error 1004 - method 'Range' of object'_Global' failed

    Please Login or Register  to view this content.
    Sheets "Sales" and "Donated" have headings "Name Date Item Price" in Row 1, Columns A-D
    and "Donated" has "=Donated" in A2

    Spent hours trying to solve it so any help would be much appreciated
    Last edited by JBeaucaire; 01-13-2013 at 04:51 AM. Reason: Added code tags, as per forum rules. Don't forget!

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Problem with copy data from "sales" sheet to each customer sheeet

    You've got too many quotes in the A2:D3 range notation. Does that fix your issue?

  3. #3
    Registered User
    Join Date
    01-13-2013
    Location
    Warwick, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Problem with copy data from "sales" sheet to each customer sheeet

    Thanks for your prompt reply but that was just a typo when I entered it on to the forum. (Its on a different computer so couldn't just copy and paste). The extra " is not in the code

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Problem with copy data from "sales" sheet to each customer sheeet

    I guess I'd need to see the workbook with the macro in it. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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