How to add a Macro or Function to organize by cell data in Excel
I'm attaching a mock example of a report that is given daily. I'm looking first to see if there's a way to take the information (for this example Cells B, C and D) and input their definition into cells E, F, and G based upon information in Sheet 2. I'm not sure if there's a Macro than can be coded for this or maybe a function, but the size of the report varies daily and having to manually check each one is time consuming so any help or ideas is appreciated.
Also, on Column A is there a formula to tell it to multiply by .01 so that it shows the correct dollar amounts, normally I just tuck it to the side and paste special but wasn't sure if there's a macro code language for that.
ExampleRecord.xlsx
Also, on Column A is there a formula to tell it to multiply by .01 so that it shows the correct dollar amounts, normally I just tuck it to the side and paste special but wasn't sure if there's a macro code language for that.
ExampleRecord.xlsx
You can use vlookup. Look at sample. I don't understand your second question. If you should multiply some data by 0.01, may be better to have separate column for this?
ExampleRecord.xlsx
ExampleRecord.xlsx
@Technodweeb: Add FALSE as last parameter of VLOOKUP, because default is closest match. In this case you will need exact match
Yes, thanks... I was just realizing my error. The biggest problem I missed was I have a $B as the first parameter in the VLOOKUP and I should have left the $ off when I copied the cells.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the help, your solution was exactly what I needed.
ExampleRecord.xlsx