Forum Discussion

fabianoars's avatar
fabianoars
Copper Contributor
Sep 22, 2021
Solved

How to link data from a column on one tab to a column on another tab?

I need to link the data from an entire column to a column from another tab so that the data from the second column receives the data from the first automatically as per the data feed.

I know it's possible to use cell to cell using the formula "=", but that only returns the value of one row, I need to return all rows of a column, automatically. What formula can I use?
  • Devon500  I'm sorry, i was so focused on the 1st few columns of the attachment and looking for the non-existent macro I didn't notice the comments in columns G and H.
    In general I would recommend just having another tab that keeps the data from each month and then 'this' tab would just perform a sum of the data from there.  Attached is an example of what i mean.

    you could also just copy values from col I and paste (values only) onto col G each month.

9 Replies

    • mtarler's avatar
      mtarler
      Silver Contributor
      I don't know that I agree. I haven't seen any metrics on it but my gut feel is that using the very simple formula:
      ='Sheet1'!A:A
      would be faster and more efficient then forcing Excel to count and calculate the populated range and then only copy that range.
      I would COMPLETELY agree with this method if the formula is complicated and especially if that range is used multiple times in the complicated formula. But in this request to just copy that column, I think it may actually be less efficient.
      Anyone have time tests on this sort of thing?
      • Juliano-Petrukio's avatar
        Juliano-Petrukio
        Bronze Contributor

        mtarler 

        By doing it ('Sheet1'!A:A), it will make reference to all 1,048,576 rows from column A.
        Also if the cell is blank, it will return ZERO as value.

         


        What he needs is the data.

         

Resources