• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLookup in VBA

H

helpthenewbie

New Member
I am very green when it comes to creating VBA or any programming for that matter. I know what I need and I think it should be fairly easy to do. It may not even need a macro and could use a formula instead? Any insight and help would be much appreciated.


This is for a billing worksheet.


It looks like it should be linked between multiple tables in the worksheet.


The Reports Draft Table is where the final product should go.


What I'm trying to do is when Column A equals one of the Type numbers on the Fuel Estimate page. It then matches the Inches to the In.Added, and populates Est Gallons and Est Pounds accordingly.

Link to the spreadsheet:
https://www.dropbox.com/s/dfe62m4qbxe37sr/pound calculation project.xls

I have more parts to this but I would like to just get this started.

Thanks!!
 

Attachments

  • pound calculation project.xls
    53 KB · Views: 6
Hi ,

It is good you have uploaded your file , but that is just one part ; can you explain , with specific reference to worksheet tabs / cells / columns , where you want the formulae , and what they should do ? I am not able to understand where you have your Fuel Estimate page or the Reports Draft Table.

Narayan
 
Hi,

The worksheets are locked in your sample file. Please could you unlock and upload a new sample file or provide the password

Regards!!
 
You must log in or register to reply here.
Back
Top