+ Reply to Thread
Results 1 to 2 of 2

Copying tables and pasting to reuse table would like formula to change with cells

  1. #1
    Registered User
    Join Date
    09-30-2020
    Location
    United States
    MS-Off Ver
    18.2008.12711.0
    Posts
    1

    Copying tables and pasting to reuse table would like formula to change with cells

    Hi, there's a chance I am going about this the complete wrong way, but I'm trying. I have tables that are used for estimating, and basically you have to copy and paste the table if there is a piece of equipment with variance of the original table and make another table to account for the other item. When you do this there is a column that does the calculation of the number of units and number of parts. example. Column D is the controller and column E is the number of pieces that go to that controller. so if you have 2 controllers with 3 switches it would be D1=1 E2=3 then they are multiplied and put in D2 for total number of switches. D2 formula is D$2*E2 there are 5 rows in D with the same formula only E changes by one each row (D3 would be D$2*E3). My issue is when I copy this table for a new controller and paste it the D$2 stays. So if pasted in D10 my formula then still will reference D$2 and and you have to change the 2 to 10 and drag it down for the other rows corresponding. May not seem like a big deal but gets rather frustrating doing it time and time again. So I guess the question is would there be a better formula so that when the tabled is copy and pasted that will not have to be done.

    Thanks

  2. #2
    Registered User
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    57

    Re: Copying tables and pasting to reuse table would like formula to change with cells

    Can you upload a copy of your spreadsheet and what you paste? Easier to see it happening.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying and pasting a formula into 100,000 cells
    By hikiwari in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2020, 06:28 PM
  2. Copying and Pasting Tables and Graphs.
    By TWG in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-08-2017, 08:30 PM
  3. Copying Excel table range to an existing PPT slide, pasting as TABLE, not as PICTURE
    By gurnblanston27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2016, 04:44 PM
  4. Copying & Pasting Values from Pivot Tables As Array
    By Mr Denove in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2013, 04:31 AM
  5. Copying and pasting a table of data with individually color filled cells
    By Paragoomba in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-18-2013, 11:49 AM
  6. [SOLVED] Copying and pasting data tables with changing row counts
    By arleutwyler in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 11:14 AM
  7. [SOLVED] Reuse of Pivot tables
    By watkincm in forum Excel General
    Replies: 2
    Last Post: 07-02-2012, 05:01 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