+ Reply to Thread
Results 1 to 6 of 6

copy and paste a client bill details of monthwise (jan-dec in sheetwise) to another sheet

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    copy and paste a client bill details of monthwise (jan-dec in sheetwise) to another sheet

    agcd name month invno inv date invamt

    monthwise bill details to be filtered a particular client and paste and merge all month in a single sheet

  2. #2
    Forum Contributor
    Join Date
    08-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: copy and paste a client bill details of monthwise (jan-dec in sheetwise) to another sh

    Please attach a sample file with desired output.

    Thanks

  3. #3
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: copy and paste a client bill details of monthwise (jan-dec in sheetwise) to another sh

    Attachment
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    08-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: copy and paste a client bill details of monthwise (jan-dec in sheetwise) to another sh

    Hello CP,

    I have made little modification on your database to solve the task

    Just copy all data in "All" sheet rather than different sheet for different month and then if you run this code then this will filter data basis on name, find the sheet with that name and if found paste the data.

    Please Login or Register  to view this content.
    [/CODE]


    Let me know if this helps.

    Regards
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: copy and paste a client bill details of monthwise (jan-dec in sheetwise) to another sh

    i am using it presently. (copy clienwise to sheetwise). My question is

    I have monthwise bill apr,may,jun (sheetwise)

    client name A (billed all three months)

    I want to copy from all the month of the CLIENT (A) into a single (consolidated) sheet

  6. #6
    Registered User
    Join Date
    04-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: copy and paste a client bill details of monthwise (jan-dec in sheetwise) to another sh

    I want to copy from all the month of the CLIENT (A) into a single (consolidated) sheet

+ 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. How to copy pivote table details and paste (replace) with values only in same sheet
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2014, 01:50 PM
  2. [SOLVED] Auto copy client details from different worksheet
    By robbie010 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2014, 10:10 AM
  3. Display Client Details Accross Multiple User Foms
    By jackhanah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2013, 10:35 PM
  4. Userform to fill sales bill details
    By aditi7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2013, 04:39 AM
  5. Replies: 2
    Last Post: 05-29-2013, 09:41 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