marku24

<div>
It took a bit of work but in the long run would be easier. &nbsp;I adjusted the page and built my objects into cells. &nbsp;Thanks
</div>


It took a bit of work but in the long run would be easier.  I adjusted the page and built my objects into cells.  Thanks

<div>
It's always best to create forms and reports using the basics, i.e. cells. Avoid MergedCells though - use centre across selection from the Format Cells dialog &nbsp;-&gt; Alignment Tab instead
</div>


It's always best to create forms and reports using the basics, i.e. cells. Avoid MergedCells though - use centre across selection from the Format Cells dialog  -> Alignment Tab instead

<div>
<div class="content wysiwyg-content">
I have an sheet in Excel that i am using as a template for a report. &nbsp;When i retrieve the requested data into the sheet i copy the sheet to another tab and value paste the data on the report so it will not change. &nbsp;The problem is that I am using objects on the report (text boxes, chevrons) that i also use a formula. &nbsp;These formulas do not get replaced by the data when i value paste the sheet and therefore their value keeps changing. &nbsp;Is there a way i can value paste the data from an object and keep its formatting?
</div>
</div>


I have an sheet in Excel that i am using as a template for a report.  When i retrieve the requested data into the sheet i copy the sheet to another tab and value paste the data on the report so it will not change.  The problem is that I am using objects on the report (text boxes, chevrons) that i also use a formula.  These formulas do not get replaced by the data when i value paste the sheet and therefore their value keeps changing.  Is there a way i can value paste the data from an object and keep its formatting?

Value Paste Data inside an Object

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.