+ Reply to Thread
Results 1 to 4 of 4

To transfer data from one sheet to another four sheets and also to pick up the higher pric

  1. #1
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    74

    To transfer data from one sheet to another four sheets and also to pick up the higher pric

    Dear All,

    I have 10 wks in the attached workbook, namely:
    1. 1) ICU
    2. 1) GW
    3. 1) Inpatient
    4. 1.1) Consolidation
    5. 1.2) PT – Consol
    6. 2) Usage
    7. 3) Consum.
    8. 3) Drugs 1
    9. 3) Drugs 2
    10. 3) Drugs 3

    and what I would like to achieve is, the final results to be displayed in those last four wks (wks 7-9).
    For wks 1-3, the code, description and prices are provided by each dept and the details inputted are varied even though it is for the same item.
    When all these come to me, I try to standardize all the items by giving it a ‘Final Name’ as shown in Col F in wks 4. Then I use pivot table to tidy up the data (wks 5).
    When it comes to billing, a patient’s usage will be summarize in wks 6 by a clerk and ultimately transferred to wks 7-10 manually by another clerk. As a result, it is always prone to human mistakes. Like the quantity miscalculated, entered into wrong column or cell, etc.
    Would someone kindly provide me with VBA code that
    1) the data can be transferred from wks 6 to wks 7-10 automatically?
    2) Will take up the highest price from wks 5 and display in wks 7-10?

    Thank you so much for your constructive input.
    Attached Files Attached Files

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: To transfer data from one sheet to another four sheets and also to pick up the higher

    There is no week number in any of your tabs.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    74

    Re: To transfer data from one sheet to another four sheets and also to pick up the higher

    Sorry, if i dont misunderstand you, i believe you mean 'wks'? It is for 'worksheet'. wks 5 means the 5th worksheet, ie. 1.2) PT - consol

  4. #4
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    74

    Re: To transfer data from one sheet to another four sheets and also to pick up the higher

    For your info, i just posted the same question in another forum

    http://www.vbaexpress.com/forum/showthread.php?t=44339

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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