Greetings-
I need help, and I don't even know if this can be done.
I need to generate a Concrete Mix Design Report, & I'm referencing several cells, to have that data appear throughout the report. This report will be fully generated & automated by entering data on multiple sheets in the file. Since, everything will reference other cell throughout the file, I wanted to see if I can generate a title, based on data.
An example of a title would be:
"3000psi, 5.00 Sack, 25% FA, AIR, WR, W/C Ratio: 0.48" whereas 3000, 5.00, 25%, & 0.48 is data in the file, & FA, AIR, & WR appear b/c YES was selected in certain drop-down menus.
Another example would be:
"3000psi, 5.00 Sack, W/C Ratio: 0.48" whereas ??% FA, AIR, & WR do not appear b/c NO was selected in certain drop-down menus.
Have I thoroughly confused you yet? I attached a file to help out.
I'm using Excel 2002 SP3 if that helps.
I really appreciate any info you can give me on this matter. Thank you in advance!!!
-Bryan
Bookmarks