Forum Discussion
Autopopulate text with check boxes into another cell
I've been asked if its possible to have a complete list of data within a spreadsheet off the print area. When we check pieces of the data, we want them to auto-populate into cells that show a scope of work to be provided and scope of work that's not included in the proposal. How do I achieve this?
Thanks,
Jeff O'Brien
VDC Manager
4 Replies
- Matt MickleBronze Contributor
Jeff-
This is certainly possible. Depending on your situation things could be pretty simple or pretty complex. I have attached a simple version (See .xlsx attachment) that demonstrates the concept. You would probably need to provide more detail for your particular situation or use my example file in context with the way your data is structured. Hope this helps.
- Jeff O'BrienCopper Contributor
Basically what I'm trying to do is to autopopulate text into the scope included section and the not included section of the attached document. We constantly bid specification sections for construction projects. It would be helpful if I could just check what sections are included and have them autopopulate the correct scope included box. If their unchecked then they belong in the not included section.
Make sense? Or am I confusing everyone?
- Matt MickleBronze Contributor
Hey Jeff-
Just wanted to follow up and see if you were still having issues with your workbook? If so, please feel free to reach back out to the community and ask additional questions.