Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2020, 11:12 AM
excelforsue excelforsue is offline How do I copy a workbook to another workbook and keep the formatting within the new workbook Windows 10 How do I copy a workbook to another workbook and keep the formatting within the new workbook Office 2016
Novice
How do I copy a workbook to another workbook and keep the formatting within the new workbook
 
Join Date: Jan 2020
Location: california
Posts: 1
excelforsue is on a distinguished road
Default How do I copy a workbook to another workbook and keep the formatting within the new workbook

I started a new job and have been asked to create a new workbook from a current workbook in order to use the workbook: My workbook contains 20 sheets of cost data on work projects in different areas. And has a summary sheet and other analyses based on the data from those sheets. This workbook is not allowing me to perform tasks I need and was somehow blocked by another user. I copied the sheets to another workbook in hopes I could use the data as I choose. The new workbook is not calculating the totals properly and some of the formulas in the summary are referring to the old workbook sheets (I want the formulas to refer to the sheets in the new workbook) How do I save the data so it only refers to the new workbook sheets?



I have also started a new sheet in the new workbook and entered many values in 2 columns and created a formula to total the values in each column and each row. The formulas do not work. (I want this resolved as well). This data in this new sheet will also be used to create more data on the same sheet.

I have tried formatting the cells to data and it doesn't work. Since it is a work item I can not provide the workbook.
Reply With Quote
  #2  
Old 01-12-2020, 03:03 AM
ArviLaanemets ArviLaanemets is offline How do I copy a workbook to another workbook and keep the formatting within the new workbook Windows 8 How do I copy a workbook to another workbook and keep the formatting within the new workbook Office 2016
Expert
 
Join Date: May 2017
Posts: 713
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
Default

a) You save the old workbook with new name. Now you have a new workbook where all formulas refer to ranges in new workbook. After that you can make any changes, delete abundant data, add new data, edit existing data, etc.

b) You create a new workbook and copy table headers and column widths from old workbook sheets into new workbook sheets (use PasteSpecial > Values and PasteSpecial > ColumnWidths). Then copy header and 1st data row from every table on old workbook, and use PasteSpecial>Formats to paste formats into according tables in new workbook.
After that you have to select a field with formula in it, copy the formula in formula bar field, and copy it to according field on new workbook. Repeat this process for every formula field in top rows of old workbook tables. Or you copy a top row from every old workbook table and use PasteSpecial > Formulas to paste it to new table, then clear all cells without formulas, and edit all cells with formulas removing references to old workbook with references to new workbook (usually you can use ReplaceAll to do this).
Now you can copy every table down for as much rows as you need, and enter your data into fields without formula (manually, or copy)
Reply With Quote
  #3  
Old 09-14-2020, 11:27 PM
shansid shansid is offline How do I copy a workbook to another workbook and keep the formatting within the new workbook Windows 10 How do I copy a workbook to another workbook and keep the formatting within the new workbook Office 2013
Novice
 
Join Date: Sep 2020
Posts: 4
shansid is on a distinguished road
Default

Copying workbook to a different MS Office version causes misalignment. In such conditions you have to use the Paste special option.
Reply With Quote
  #4  
Old 09-15-2020, 03:37 AM
Purfleet Purfleet is offline How do I copy a workbook to another workbook and keep the formatting within the new workbook Windows 10 How do I copy a workbook to another workbook and keep the formatting within the new workbook Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

i would do as ArviLaanemets suggested, the safest way to keep all formulas and formatting the same, especially in a multi worksheet workbook.

it is possible to select all sheets, right click on the worksheet tab, move or copy, tick create a copy and select new book.

But there isnt look of difference between the 2
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing a Workbook that contains array formula link to other workbook Ahmad.rage22@gmail.com Excel 0 03-12-2018 10:15 PM
Copy data as well as formatting from one workbook to another. LearnerExcel Excel 1 03-10-2018 01:35 PM
vba code for integrating particular information from different workbook to one workbook klpw Excel Programming 1 12-28-2015 09:48 AM
data entered in one workbook should be updated in other relevant workbook based on the date vedha Excel 0 04-24-2015 08:45 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft