I have one tab contains data and one tab is the tax receipt template.
It also may be faster to perform a single UPDATE as is the case with the example above versus uploading (INSERT...
SELECT) the data and then performing an UPDATE based on the new table.
In addition, by using the commands listed above versus a two step process the overall code may be a little bit cleaner.
A second consideration with SQL Server 2005 is that the Surface Area Configuration setting must be enabled to use this code in either case.
With mouse-clicks you can transfer values from worksheet 1 to worksheet 2 or vice versa.