Todays problem is I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
Todays problem is I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
Yeah, you just link the cells on sheet 2 etc. to the cells in sheet 1.
Then whatever is in cell A1 on sheet1 will automatically get pulled into cell A1 on sheet2.Please Login or Register to view this content.
Like that?
If you mean like: copy sheet1.cell1, and paste to sheet2.cell1, and sheet3.cell1, etc...
If so, copy the source cells, select the 1st target sheet, hold shift key and click the last sheet, click the target cell, press enter.
All copied cells will paste to all sheets, in same cells.
1 option would be to simply reference the 1st sheet on all te other sheets...
=sheet1!A1
Another option, if you just want to "punch" the info through to all sheets.
You said "Form", but assuming you just have a table that looks like a form...
click on the 1st sheet you want, then hold SHIFT and click on the tyab of the last sheet you have. You will now have GROUPED all those sheets. Whatever you do to 1 sheet will be done to them all.
When you are finished, make your you click on another tab, or right-click a tab in the group and select Ungroup
If these dont work for you, upload a sample workbook, showing what you have and what you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks