Closed Thread
Results 1 to 2 of 2

Copy formats & data on calculated data

  1. #1
    Registered User
    Join Date
    01-08-2017
    Location
    Barcelona
    MS-Off Ver
    Office 2019
    Posts
    82

    Copy formats & data on calculated data

    Hi !

    I don't know if you can make it with formula .... I have a sheet with a table with calculated data and format. And I need to copy only that table to another excel file every week. I can make if copy values and after copy format but I want to know if there are another method more easy to do or any formula or key combination.

    Thanks to all

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Copy formats & data on calculated data

    Forum-induced duplicate thread (closed)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculated field greyed out after adding data to the data model
    By paula10 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-20-2017, 09:12 AM
  2. [SOLVED] Pulling individual data in pivot table when data repeats. Need Calculated Field
    By ChemistB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-11-2017, 02:12 PM
  3. Required mix data format as organized data formats
    By sachin3467 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2016, 04:39 AM
  4. Replies: 4
    Last Post: 10-01-2014, 03:18 PM
  5. [SOLVED] how can i copy paste data with the original cell formats?
    By sumesh56 in forum Excel General
    Replies: 2
    Last Post: 04-16-2013, 09:45 PM
  6. Copy Data from one Sheet to Another Sheet including comment and formats
    By SubhasreeM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2012, 07:07 AM
  7. Replies: 3
    Last Post: 10-28-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1