+ Reply to Thread
Results 1 to 2 of 2

Autofill data in adjoining columns based on value selected in first column

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    office 2010

    Autofill data in adjoining columns based on value selected in first column


    I work for a charitable organization and I am developing a spreadsheet to keep a track of the medicines we dispense to the patients who visit our free clinic. I have uploaded my spreadsheet so that you can see what I have done. There is a Master Sheet which contains data of the medicines we use in our clinic. We enter the medicines dispensed each day in the "Daily Drug Dispensation Chart". I have used VlookUp formulas so that when the Brand Name is selected in the first column in the "Daily Drug Dispensation Chart", the Generic Name, Batch No. and Expiry Date of that medicine is autofilled in the other columns from the Master Sheet.

    Now the problem: the Brand Name and Generic Name do not change in the Master Sheet. However, once one batch of a particular Brand is finished, we have to change the Batch No. and Expiry Date in the Master Sheet. But as soon as this is done, the previous entries of that Brand Name get auto-updated to the new Batch No. and Exp. Date. We want that this should not happen. Is there some VBA code I can use which will still achieve this autofill from the Master Sheet, but then the values do not get auto-updated, whenever the Batch No. and Exp. Date are updated in the master sheet?

    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite

    Re: Autofill data in adjoining columns based on value selected in first column

    Not sure to got it right, can you explain with an example the issue you are running into
    - Battle without fear gives no glory - Just try

+ 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. Replies: 1
    Last Post: 10-21-2013, 11:32 AM
  2. [SOLVED] Autofill based on data in other columns
    By db3712 in forum Excel General
    Replies: 8
    Last Post: 11-07-2012, 03:34 PM
  3. [SOLVED] Counting values in an adjoining column of non-null data
    By annewtsn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-25-2012, 04:33 PM
  4. [SOLVED] Excel 2007 : Autofill based on column data
    By db3712 in forum Excel General
    Replies: 5
    Last Post: 06-28-2012, 10:06 AM
  5. Autofill Columns with data from another column
    By Mackb in forum Excel General
    Replies: 4
    Last Post: 12-20-2010, 06:26 PM


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