guitarman765
New Member
- Joined
- May 23, 2018
- Messages
- 1
First post so please be gentle, im a novice with Excel and this is a doozy I think? Ok so I have a problem. Ill start with what im trying to accomplish and what ive done so far and then the problem. (Sorry if its too detailed)
End goal is users input information into a form I created and that form automatically adds the information the header, footer and in between and then the user can print off or SAVE AS only (do not want inputted info to stay when closed) the CompletedSheet page
What ive done so far.
HeaderSheet that prints on every page. (never changes size)
FooterSheet that prints on every page. (never changes size)
FormFillSheet where user inputs data. (has a list from 1-60) Will never be 0 and never more than 60.
CompletedSheet That combines the header and footer.
I know how to link a form to symbols (yes gets this picture no gets this picture, etc.)
Footer has 9 separate image spaces that are the same size that are linked to answers on the formfillsheet and work fine.
I dont need the header and footers to show up on completed form just yet (it can wait)
My problem is I need to take only the rows from the FormFillSheet page (1-60 list) that have information added into them in a certain field (description) to be added into the CompletedSheet. I also need it to where if the text is too long in the merged cells in the form fill sheet, the row is automatically doubled in the CompletedSheet but keeping the same number. (if that makes sense?) I need the whole row copied including formulas and sizes, etc.
Example.
(FormFillSheet) |||| = Cells
|1|Take one piece |(symbol select)| data from fill sheet |
|2|Put in bin |(symbol select)| data from fill sheet |
|3|Throw away bin and then go home |(symbol select)| data from fill sheet |
|4| Have a good day |(symbol select)| data from fill sheet |
|5| |(symbol select)| data from fill sheet |
|6| |(symbol select)| data from fill sheet |
|7| |(symbol select)| data from fill sheet |
|8| |(symbol select)| data from fill sheet |
VVV(all the way to 60 but not all 60 are filled)---------->VVV
On CompletedSheet (What I need)
heard info|header info|
heard info|header info|
heard info|header info|
----------------------
|1|Take one piece |SYMBOL| data from fill sheet |
|2|Put in bin |SYMBOL| data from fill sheet |
|3|Throw away bin and |SYMBOL| data from fill sheet |
then go home.
|4| Have a good day |SYMBOL| data from fill sheet |
-----------------------------
footer info | footer info| footer info|
footer info | footer info| footer info|
footer info | footer info| footer info|
Pretty much what it is is a user fills out a form and a list of steps to complete a task and picks a symbol. That info is generated onto a completed sheet (header and footer prints on each page) but only the steps they list are added in between the header and footer, not the whole 60 unless they input 60 steps.
Thank you all and please let me know how I can make the post better for next time I have a question!
P.S. I cant upload the actual form because my Company is huge on not sharing work documents. So I can really only work on this at work and make a fake mock up at home. Thank you!
End goal is users input information into a form I created and that form automatically adds the information the header, footer and in between and then the user can print off or SAVE AS only (do not want inputted info to stay when closed) the CompletedSheet page
What ive done so far.
HeaderSheet that prints on every page. (never changes size)
FooterSheet that prints on every page. (never changes size)
FormFillSheet where user inputs data. (has a list from 1-60) Will never be 0 and never more than 60.
CompletedSheet That combines the header and footer.
I know how to link a form to symbols (yes gets this picture no gets this picture, etc.)
Footer has 9 separate image spaces that are the same size that are linked to answers on the formfillsheet and work fine.
I dont need the header and footers to show up on completed form just yet (it can wait)
My problem is I need to take only the rows from the FormFillSheet page (1-60 list) that have information added into them in a certain field (description) to be added into the CompletedSheet. I also need it to where if the text is too long in the merged cells in the form fill sheet, the row is automatically doubled in the CompletedSheet but keeping the same number. (if that makes sense?) I need the whole row copied including formulas and sizes, etc.
Example.
(FormFillSheet) |||| = Cells
|1|Take one piece |(symbol select)| data from fill sheet |
|2|Put in bin |(symbol select)| data from fill sheet |
|3|Throw away bin and then go home |(symbol select)| data from fill sheet |
|4| Have a good day |(symbol select)| data from fill sheet |
|5| |(symbol select)| data from fill sheet |
|6| |(symbol select)| data from fill sheet |
|7| |(symbol select)| data from fill sheet |
|8| |(symbol select)| data from fill sheet |
VVV(all the way to 60 but not all 60 are filled)---------->VVV
On CompletedSheet (What I need)
heard info|header info|
heard info|header info|
heard info|header info|
----------------------
|1|Take one piece |SYMBOL| data from fill sheet |
|2|Put in bin |SYMBOL| data from fill sheet |
|3|Throw away bin and |SYMBOL| data from fill sheet |
then go home.
|4| Have a good day |SYMBOL| data from fill sheet |
-----------------------------
footer info | footer info| footer info|
footer info | footer info| footer info|
footer info | footer info| footer info|
Pretty much what it is is a user fills out a form and a list of steps to complete a task and picks a symbol. That info is generated onto a completed sheet (header and footer prints on each page) but only the steps they list are added in between the header and footer, not the whole 60 unless they input 60 steps.
Thank you all and please let me know how I can make the post better for next time I have a question!
P.S. I cant upload the actual form because my Company is huge on not sharing work documents. So I can really only work on this at work and make a fake mock up at home. Thank you!
