castilian07
New Member
- Joined
- Dec 19, 2017
- Messages
- 7
[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 609"]
<colgroup><col width="41" style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <col width="64" style="width: 48pt;" span="2"> <col width="114" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4169;"> <col width="64" style="width: 48pt;" span="3"> <tbody>[TR]
[TD="class: xl150, width: 41, bgcolor: transparent"][/TD]
[TD="class: xl151, width: 770, bgcolor: transparent, colspan: 9, align: center"]Title[/TD]
[/TR]
[TR]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl130, bgcolor: transparent"][/TD]
[TD="class: xl131, bgcolor: transparent, colspan: 9, align: center"]BATCH CONTROL SHEET[/TD]
[/TR]
[TR]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl133, bgcolor: transparent"] [/TD]
[TD="class: xl133, bgcolor: transparent"] [/TD]
[TD="class: xl133, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl135, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl136, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Business Unit:[/TD]
[TD="class: xl162, bgcolor: transparent, colspan: 2"]Business Unit[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Batch:[/TD]
[TD="class: xl163, bgcolor: transparent, colspan: 2"]168826[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Business ID #:[/TD]
[TD="class: xl159, bgcolor: transparent, colspan: 2"]502[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Reference:[/TD]
[TD="class: xl163, bgcolor: transparent, colspan: 2"]04.18 #2 [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl140, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl140, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Prepared By:[/TD]
[TD="class: xl159, bgcolor: transparent, colspan: 2"]Accountant[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Input Date:[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]5/10/2018[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Period to Post:[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]04/30/18[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Approved By:[/TD]
[TD="class: xl141, bgcolor: transparent"] [/TD]
[TD="class: xl141, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl160, bgcolor: transparent, colspan: 2"]The Boss[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl142, width: 114, bgcolor: transparent"]Description: [/TD]
[TD="class: xl154, width: 128, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl142, width: 114, bgcolor: transparent"][/TD]
[TD="class: xl154, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl155, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl161, width: 242, bgcolor: transparent, colspan: 3"]Record[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Control Total:[/TD]
[TD="class: xl156, bgcolor: transparent, colspan: 2"] $ 276,537.31 [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl154, width: 128, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Reverse Entry:[/TD]
[TD="class: xl157, bgcolor: transparent, colspan: 2"]No[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Reversing Date:[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]Not Applicable[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Solomon Module:[/TD]
[TD="class: xl159, bgcolor: transparent, colspan: 2"]GL[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl144, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl146, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl147, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]
each value is a text box.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I created 20 text boxes and grouped them together to come up with a form worksheet. My issue is when I copy tab (Ctrl copy tab) to create another tab with different values in it all in the same cells. At this point nothing has changed but the number in the linked cells. The problem is that my text boxes do not update to the current tab but are linked to the previous tab for which I created the text boxes in. I have to manually click on each text box (F2) to update the values to the current worksheet tab. Does anyone know a faster way update the text boxes to the current worksheet tab? Please. Thanks. I added a basic version of my text box form to give a visual.
<tbody>[TR]
[TD][TABLE="width: 609"]
<colgroup><col width="41" style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <col width="64" style="width: 48pt;" span="2"> <col width="114" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4169;"> <col width="64" style="width: 48pt;" span="3"> <tbody>[TR]
[TD="class: xl150, width: 41, bgcolor: transparent"][/TD]
[TD="class: xl151, width: 770, bgcolor: transparent, colspan: 9, align: center"]Title[/TD]
[/TR]
[TR]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl129, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl130, bgcolor: transparent"][/TD]
[TD="class: xl131, bgcolor: transparent, colspan: 9, align: center"]BATCH CONTROL SHEET[/TD]
[/TR]
[TR]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl133, bgcolor: transparent"] [/TD]
[TD="class: xl133, bgcolor: transparent"] [/TD]
[TD="class: xl133, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl135, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl136, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Business Unit:[/TD]
[TD="class: xl162, bgcolor: transparent, colspan: 2"]Business Unit[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Batch:[/TD]
[TD="class: xl163, bgcolor: transparent, colspan: 2"]168826[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Business ID #:[/TD]
[TD="class: xl159, bgcolor: transparent, colspan: 2"]502[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Reference:[/TD]
[TD="class: xl163, bgcolor: transparent, colspan: 2"]04.18 #2 [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl140, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl140, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Prepared By:[/TD]
[TD="class: xl159, bgcolor: transparent, colspan: 2"]Accountant[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Input Date:[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]5/10/2018[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Period to Post:[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]04/30/18[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Approved By:[/TD]
[TD="class: xl141, bgcolor: transparent"] [/TD]
[TD="class: xl141, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl127, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl160, bgcolor: transparent, colspan: 2"]The Boss[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl142, width: 114, bgcolor: transparent"]Description: [/TD]
[TD="class: xl154, width: 128, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl142, width: 114, bgcolor: transparent"][/TD]
[TD="class: xl154, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl155, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl161, width: 242, bgcolor: transparent, colspan: 3"]Record[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Control Total:[/TD]
[TD="class: xl156, bgcolor: transparent, colspan: 2"] $ 276,537.31 [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl154, width: 128, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Reverse Entry:[/TD]
[TD="class: xl157, bgcolor: transparent, colspan: 2"]No[/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Reversing Date:[/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 2"]Not Applicable[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl137, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"]Solomon Module:[/TD]
[TD="class: xl159, bgcolor: transparent, colspan: 2"]GL[/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl138, bgcolor: transparent"] [/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl128, bgcolor: transparent"][/TD]
[TD="class: xl139, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl144, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl146, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl145, bgcolor: transparent"] [/TD]
[TD="class: xl147, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]
each value is a text box.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I created 20 text boxes and grouped them together to come up with a form worksheet. My issue is when I copy tab (Ctrl copy tab) to create another tab with different values in it all in the same cells. At this point nothing has changed but the number in the linked cells. The problem is that my text boxes do not update to the current tab but are linked to the previous tab for which I created the text boxes in. I have to manually click on each text box (F2) to update the values to the current worksheet tab. Does anyone know a faster way update the text boxes to the current worksheet tab? Please. Thanks. I added a basic version of my text box form to give a visual.