I have a spreadsheet with hundreds of tabs attached. I would like to add some data to each tab. Data would be the same but will change with each tab due to data that is already there. I would like to add this new item after the last item on the page.
see mockup below where the red font I may change with each tab in the spreadsheet. all help is appreciated !
[TABLE="width: 383"]
<colgroup><col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="356" style="width: 267pt; mso-width-source: userset; mso-width-alt: 13019;"> <tbody>[TR]
[TD="width: 154, bgcolor: transparent"]1
[/TD]
[TD="width: 356, bgcolor: transparent"]x
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]xx
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]fake data
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]12
[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]4
[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]#[/TD]
[TD="bgcolor: transparent"]here is where I want to add the new item and qty. [/TD]
[/TR]
</tbody>[/TABLE]
see mockup below where the red font I may change with each tab in the spreadsheet. all help is appreciated !
[TABLE="width: 383"]
<colgroup><col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="356" style="width: 267pt; mso-width-source: userset; mso-width-alt: 13019;"> <tbody>[TR]
[TD="width: 154, bgcolor: transparent"]1
[/TD]
[TD="width: 356, bgcolor: transparent"]x
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]xx
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]fake data
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]12
[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]4
[/TD]
[TD="bgcolor: transparent"]fake data[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]#[/TD]
[TD="bgcolor: transparent"]here is where I want to add the new item and qty. [/TD]
[/TR]
</tbody>[/TABLE]