Hey guys .. I'm stuck on a peculiar problem & I don't even know where to start, well I don't even know if it's possible.
I am basically trying to write a macro that compares cell values & based on those cell values the other cell will be autofilled. I basically have price data for different months & this data is dynamic so I can't even do it based on rows since I would be using this macro as a standard among different workbooks.
It basically would be comparing data across 3 cells. One is the Month .. Two is the Item in that month & the third would be to see if there is an amount in the third column, if all these values are true it would do an autofill in the empty cell below the amount(whatever that amount may be). I know it is perhaps an If-Then Statement but I would be doing this for specific columns. So I would have to define that as well.
I hope this isn't too confusing but I'm attaching a sample piece of my workbook to give you guys a picture of what I'm talking about. I need an autofill in the Items & Amount Column based on values from the Month Column. So basically if there is January & there is an Item, the Amount of that would be the same based on the cell above it & it should run only until the month of January & if there is no Item in February, it should be blank for the Amounts coinciding with February. Same with the Items Column I need an autofill in it depending on the Months column, If there is 1 Item and 3 values of January then I want the autofill for 3 cell values(In the Items Column) until it finds the next value and tries to do the same autofill for the next month (February).
I'm just confused talking about it, but hopefully the attachment can give you an idea of what I'm trying to get at. Without even too much scripting can someone write a =IF statement within a cell that may solve this problem & I can get it hardcoded through the Macro recorder.
Any comments on this would be highly appreciated.
Thanks!