Automatically add rows based on inputs.

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!
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top