Hi everybody!!!!
I have a piece of code that I need some help with.
Workbooks("Olson Bros Bid Information Sheet.xls").Sheets("data").Range( ? ).Value = ActiveWorkbook.Sheets("cost sheet").Range("AH7")
The help I need is inregards to the ?. I have a formula that I use in my regular worksheet that gives me the correct range. Here is the formula:
="E"&TEXT((MATCH(AH7,'[Olson Bros Bid Information Sheet.xls]data'!$B$5:$B$281,0)+4),"0")
I'm not sure how to correctly write the above code to include the formula.
thanks for any help in advance
I have a piece of code that I need some help with.
Workbooks("Olson Bros Bid Information Sheet.xls").Sheets("data").Range( ? ).Value = ActiveWorkbook.Sheets("cost sheet").Range("AH7")
The help I need is inregards to the ?. I have a formula that I use in my regular worksheet that gives me the correct range. Here is the formula:
="E"&TEXT((MATCH(AH7,'[Olson Bros Bid Information Sheet.xls]data'!$B$5:$B$281,0)+4),"0")
I'm not sure how to correctly write the above code to include the formula.
thanks for any help in advance