Hi,
I need help figuring out the best way to use the data in sheet 2 to populate all the fields in sheet1. Ultimately, sheet1 will be converted to PDF when all the information is gathered. I'm struggling with making it look good. I'm Currently using If Statements for the yes no questions something along the lines of =IF(Sheet1!I2="Yes","e. Fast Idle Circuit: Yes_X__ No____","e. Fast Idle Circuit: Yes____ No_X__"), and a Concatenate for the fill in the blank areas. However I feel like there is/should be a better way to do this (maybe a macro) and make it look good with everything underlines and consistent. If someone can help get me started on figuring this out I would appreciate it. I hope its clear what I want. Thanks.
I need help figuring out the best way to use the data in sheet 2 to populate all the fields in sheet1. Ultimately, sheet1 will be converted to PDF when all the information is gathered. I'm struggling with making it look good. I'm Currently using If Statements for the yes no questions something along the lines of =IF(Sheet1!I2="Yes","e. Fast Idle Circuit: Yes_X__ No____","e. Fast Idle Circuit: Yes____ No_X__"), and a Concatenate for the fill in the blank areas. However I feel like there is/should be a better way to do this (maybe a macro) and make it look good with everything underlines and consistent. If someone can help get me started on figuring this out I would appreciate it. I hope its clear what I want. Thanks.
