Referencing cells within Excel

[DIVINEDAR0956]

How do I loop in a cell to reference it in an entire workbook? For instance, I have an excel spreadsheet that is used for input and then the information is transfered into an access database. There are labor codes that have hours and material cost amounts entered into the cells following the cell reference of the labor code, i.e., F23-Q23 has the labor code AW, EN, STF, CE, etc. and then there are 12 cells following each labor code that is filled in with the number of hours that the labor code is to do for months 1-12. Then I have a workbook named "HRSENTER" which holds all the amounts entered into this spreadsheet. In this HRSENTER workbook I want to tell a cell that if F24:F35 is greater than "0" then display or type in "AW", but I want that cell to loop in that workbook as the other workbook is filled in. Right now if have this formula but it's not working "=IF('01.100.00'!R23:R37>0,CELL("contents", '01.100.00'!E23:E37),"&quot". I pray someone can help me or give me other ideas on how to achieve the information.

 

[Darrylles]

Hiya,

Get punctuation and paragraph training mate.

Just communicate the problem without frustrating ME.

In any event (grudgingly), goto tables in the database; in Tables create a New 'LINK TABLE', change the 'Type' to Excel and search out the spreadsheet.
Do this for each worksheet.

You'll find it easier to control via Access (and via Access queries).

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[DIVINEDAR0956]

Thank you for your help and it worked for what I wanted it to do.