I know, I know - I shouldn't even be using Excel!
September 26, 2008 11:52 AM Subscribe
ExcelFilter: How can I create a spreadsheet that automatically copies a certain type of cell from one column to another?
posted by CXImran to Computers & Internet (7 answers total)
So I've got this spreadsheet where I paste a set of values into Columns 'A' and 'B' regularly. Column 'A' has a set of names and Column 'B' has a set of dates.
What I want to do is to be able to paste new data regularly into columns 'A' and 'B', but have columns 'C' and 'D' report only data that was flagged as given in the last 14 days.
I COULD just paste it in the order that I get the data, but unfortunately more often than not the data I'm working with isn't given to me chronologically. What I'd like to do is have all the data dynamically update to the last 14 days so that when I generate a certain graph it only uses the data that I want.
Do any Excel wizards know of good ways to do this?