Forum Discussion
How to link data from a column on one tab to a column on another tab?
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.
So why are you transferring the data? is this some sort of data file that is continuously updated/overwritten by something else? Maybe you could give us a big picture so we aren't trying to guess. If it is a 1 time move then cut and paste, but I doubt that is the case. If the original file keeps getting appended then an external reference from 1 sheet to the other may be best. If the file get overwritten and you need to save the former data then a macro will probably be necessary.
As for adding the column to another column, will the 2 columns be the same length? will 1 always be longer than the other? Do you care if there are zeros filled down the 'empty' cells?
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.
- mtarler Thank you for the reply. Yes, this file gets updated each month for a year or two. Currently we manually update the previous funding column to continually add to that total and then zero out the current column to prepare for the new numbers to be input. It just feels risky to have such human error possibilities. Years ago, I worked with this type of spreadsheet but was able to click a button to create a new month. Excel moved all figures appropriately and I was able to simply 'save as' for my new month and enter in current info. I'm trying to recreate the magic. I'm able to have a macro state that my previous column will equal my current column which is lovely until I zero out my current column and then of course the previous column follows suit. I'm able to have my previous column equal the actual numbers of my current column and then zero out current. But I am unable to figure out how to have my current column numbers get added to the previous column each time I click the button to start a new month. Your idea of an additional tab might be my best bet at this point. Oh! Then, perhaps I could create a column that always pulls from the totals on my other tab. It's still manual entry but it does feel more secured than the current procedure
- If you look at the attachment that is basically what I did. The monthly tab has columns of number for that month and then the 'original' tab (sheet1) automatically pulls the sum of all of them for the cumulative column and the last column for the 'current month'
