Auto Populate troubles

    Good morning Fellow Excelers,


    Having a few issues trying to nail a VB porject I have going on here. I have attached the files, in a workbook setup. First off what Im trying to get accomplished if its possible, Is a VB tool that will allow the connected Billing sheet be auto populated with information from the CO2 Log when the information is input into one cell. What IM trying to do is have the Information in column C of the CO2 report to the billing sheet, once the number in column c is input into the billing sheet in I4-J4, all associated info on the rest of that table gets input into corresponding spots on the billing sheet. So than as the file shows all of that information they would need populates into the corresponding spots on that billing sheet. It has where the info should transfer too already shown on the attached. I have another thread/stream written for another form I use that I altered to try and accomplish the same task but unfortunately I dont think it will do what I need as the info that was transfering to the same layout is just to another sheet. So like table for like table, this information needs to get split up and input into the associated places. Any assitance would be more than appreciated. Thank you for your time.


    Anthony




    forum.ozgrid.com/index.php?attachment/56365/

    Re: Auto Populate troubles


    I have since made a few attempts to narrow the field down by individually telling VB where to send that specific information but that didnt fix the runtime error.

    Re: Auto Populate troubles


    Copying to the individual cells doesnt work I have tried a few different ways of accomplishing it. It has to be a vlookup and pushing option but im not the best at the vlookup options and codes. Still stumped....

    Re: Auto Populate troubles


    G4: =INDEX('CO2 Log'!$A$3:$N$5,MATCH($I$4,'CO2 Log'!$C$3:$C$5,0),10)


    The 10 at the end is the column number. All you have to do is change that every time you paste it to get the right column number for PO, Recevied by, etc, etc. So many times a macro is not needed.

    Learning the hard way, with a few good books and the help of an online forum.
    Always interested in learning more, and discovering what Excel can really do.

    Re: Auto Populate troubles


    Perfect that does exactly what I need it to. Thank you very much.


    Now what Im trying to accomplish is an if statement that will look at c15 and if a cc was used than it calculates a different total. =A23*16+IF(C15=,A23*0.5,0) is what I have came up with im just not sure how to tell excel that no mater what the value as long as something is in that box it multiplies it by .50 which is the charge for using a CC. Let me know if that doesnt make sense.

    Re: Auto Populate troubles


    Ok I had it down pat and than when I saved and closed the document it no longer works properly. I figured out the formula for the above post. But again Im still having the issue of it not grabbing that information. It was working perfect I added a few columns and fixed a few of the other formulas but didnt alter them and they broke. Any help would again be more than appreciated.


    forum.ozgrid.com/index.php?attachment/56549/

    Re: Auto Populate troubles


    You're storing the invoice number on the CO2 Log (Column C) as text, instead of a number. You can't match a number to a text string, unless you convert the number to a text string, and subsequently match text to text.


    Change C to numbers instead of text.

    Learning the hard way, with a few good books and the help of an online forum.
    Always interested in learning more, and discovering what Excel can really do.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login