Autofill from list

%3CLINGO-SUB%20id%3D%22lingo-sub-1209211%22%20slang%3D%22en-US%22%3EAutofill%20from%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1209211%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20to%20take%20a%20project%20which%20has%20two%20dates%20associated%20with%20it%2C%20put%20all%20of%20them%20into%20one%20set%20of%20columns%20and%20then%20use%20those%20to%20track%20additional%20data%20with.%26nbsp%3B%3CBR%20%2F%3EMy%20biggest%20issue%20is%20getting%20the%20list%20of%20date%2Fprojects%20made%20and%20then%20taking%20that%20data%20to%20my%20%22Summary%22%20sheet%20and%20making%20it%20so%20that%20when%20new%20projects%20are%20added%2C%20the%20rows%20and%20projects%20don't%20get%20mixed%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1209211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1209358%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20from%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1209358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F574377%22%20target%3D%22_blank%22%3E%40Xiiharu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20not%20clear%20(to%20me%2C%20at%20any%20rate)%20why%20you%20don't%20just%20enter%20the%20data%20in%20the%20first%20place%20in%20the%20format%20shown%20on%20your%20summary%20page.%20It%20can%20always%20be%20sorted%20(%3CSTRONG%3EData....Sort..%3C%2FSTRONG%3E.)%20so%20that%20it%20doesn't%20get%20mixed%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20explain%20the%20necessity%2C%20if%20any%2C%20for%20entering%20data%20one%20way%20but%20basically%20using%20it%20in%20another%20(and%20fairly%20stable%20or%20consistent)%20fashion%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20no%20doubt%20are%20ways%20to%20use%20Data%20Filter%2C%20or%20other%20capabilities%2C%20to%20accomplish%20what%20you're%20asking%3B%20I'm%20wanting%20an%20explanation%20of%20how%20that%20specific%20request%20makes%20sense.%20There%20are%20other%20ways%20you%20could%20track%20the%20projects%20using%20various%20database%20functions%2C%20filters%2C%20sorts%2C%20etc.%20But%20let's%20take%20a%20look%20at%20the%20basic%20design%20first%2C%20if%20you%20don't%20mind.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1209784%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20from%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1209784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BThe%20main%20reason%20is%20that%20I'm%20being%20asked%20to%20keep%20the%20input%20data%20and%20the%20display%20data%20separate%20from%20each%20other.%20My%20thoughts%20to%20achieve%20this%20was%20to%20do%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20have%20the%20data%20combined%20into%20a%20new%20column%20and%20then%20have%20the%20summary%20sheet%20read%20off%20of%20that.%20or%3C%2FP%3E%3CP%3E2.%20Have%20the%20Summary%20sheet%20read%20from%20the%20data%20in%20the%20Data%20Entry%20tab%20and%20drag%20fill%20the%20formula%20in%20but%20I%20don't%20know%20if%20you%20can%20drag%20fill%20alternate%20lines.%20I%20was%20gonna%20try%20to%20do%20A2%2C%20B2%2C%20A3%2C%20B3%2C%20A4%2C%20etc.%20However%20when%20I%20try%20I%20get%2C%20the%20data%20in%2C%20all%20I%20get%20is%20A2%2C%20B2%2C%20A4%2C%20B4%2C%20A6%2C%20B6%2C%20etc.%3CBR%20%2F%3EI%20also%20need%20the%20Summary%20tab%20to%20keep%20the%20cell%20color%20when%20it%20is%20moved%20to%20the%20new%20page.%20This%20is%20one%20of%20the%20bigger%20reasons%20I%20need%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm looking to take a project which has two dates associated with it, put all of them into one set of columns and then use those to track additional data with. 
My biggest issue is getting the list of date/projects made and then taking that data to my "Summary" sheet and making it so that when new projects are added, the rows and projects don't get mixed up.

2 Replies

@Xiiharu 

 

It's not clear (to me, at any rate) why you don't just enter the data in the first place in the format shown on your summary page. It can always be sorted (Data....Sort...) so that it doesn't get mixed up.

 

Can you explain the necessity, if any, for entering data one way but basically using it in another (and fairly stable or consistent) fashion?

 

There no doubt are ways to use Data Filter, or other capabilities, to accomplish what you're asking; I'm wanting an explanation of how that specific request makes sense. There are other ways you could track the projects using various database functions, filters, sorts, etc. But let's take a look at the basic design first, if you don't mind.

@mathetes The main reason is that I'm being asked to keep the input data and the display data separate from each other. My thoughts to achieve this was to do 

1. have the data combined into a new column and then have the summary sheet read off of that. or

2. Have the Summary sheet read from the data in the Data Entry tab and drag fill the formula in but I don't know if you can drag fill alternate lines. I was gonna try to do A2, B2, A3, B3, A4, etc. However when I try I get, the data in, all I get is A2, B2, A4, B4, A6, B6, etc.
I also need the Summary tab to keep the cell color when it is moved to the new page. This is one of the bigger reasons I need this.