• 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.

VBA Macro to get amount in Master Sheet

I have an excel file which I want to get the amount in the master sheet from the datasheet, I have tried the formula with vlookup and match it works only in 1st row.
could you please help me with the excel formula
1. in the datasheet this month we have data little however in next month the data may add.
2. looking for a dynamic formula that can be entered in A1.
3. I am looking with two criteria here with column A and column B to match the data in the datasheet
I want this to be built as a macro file.
 

Attachments

  • Book1.xlsx
    82 KB · Views: 9
Back
Top