Excel question

%3CLINGO-SUB%20id%3D%22lingo-sub-1683563%22%20slang%3D%22en-US%22%3EExcel%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1683563%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20an%20excel%20spreadsheet%20for%20our%20daily%20production%20reporting%20so%20we%20have%20one%20spreadsheet%20for%20every%20day%20of%20the%20work%20week%20with%20numbers%20in%20cells%20just%20for%20that%20day%20by%20date.%20How%20can%20I%20pull%20cell%20data%20from%20these%20sheets%20by%20date%20to%20a%20single%20spreadsheet%20showing%20multiple%20dates.%20Currently%20I%20cursor%20through%20the%20cells%20and%20change%20the%20date%20manually.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1683563%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-1683770%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1683770%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F798740%22%20target%3D%22_blank%22%3E%40ppc12000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22alt-edited%22%3Etransfer%20results%20from%20a%20different%20Excel%20tables%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Emaybe%20I%20misunderstood%20something%20...%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eas%20is%20unfortunately%20often%20the%20case%20recently%3C%2FSPAN%3E...%20hmm%20wonder..%20%3CSPAN%20class%3D%22alt-edited%22%3Eneed%20glucose%3C%2FSPAN%3E%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%20%3CSPAN%3Eso%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%3D%20IF%20(table1!%20B2%20%3D%20table2!%20A2%3B%20table2!%20B2)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%3D%20IF%20-%26gt%3B%20the%20comparative%20query%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ETable1!%20B2%20-%26gt%3B%20in%20tab1%20in%20cell%20B2%20is%20the%20first%20number%20to%20be%20compared%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ETable2!%20A2%20-%26gt%3B%20in%20tab2%20in%20cell%20A2%20the%20second%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eas%20far%20as%20the%20query%2C%20as%20long%20as%20the%20cells%20have%20been%20selected%20correctly%20and%20since%20the%20content%20is%20now%20the%20same%2C%20then%20appears%20in%20the%20cell%20in%20which%20this%20formula%20is%20(i.e.%20here%20O2)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%3D%20VLOOKUP%20(B2%2C%20Sheet2!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eyou%20can%20only%20insert%20one%20%22%22%20for%20different%20entries%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20B2%20%3D%20table2!%20A2%3B%20table2!%20B2%3B%20%22%22)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EBut%20that's%20how%20it%20should%20work%20...%20%22%20...%20is%20without%20a%20test.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20Ps.%20The%20formulas%20have%20been%20translated%20from%20German%20with%20an%20Excel%20translator.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%3EWithout%20a%20file%20(without%20sensitive%20data)%20it%20is%20always%20difficult%20to%20understand%20exactly%20what%20is%20required.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I use an excel spreadsheet for our daily production reporting so we have one spreadsheet for every day of the work week with numbers in cells just for that day by date. How can I pull cell data from these sheets by date to a single spreadsheet showing multiple dates. Currently I cursor through the cells and change the date manually. 

1 Reply
Highlighted

@ppc12000 

 

transfer results from a different Excel tables

maybe I misunderstood something ...as is unfortunately often the case recently...hmm wonder..need glucose
so:
= IF (table1! B2 = table2! A2; table2! B2)

= IF -> the comparative query
Table1! B2 -> in tab1 in cell B2 is the first number to be compared
Table2! A2 -> in tab2 in cell A2 the second

as far as the query, as long as the cells have been selected correctly and since the content is now the same, then appears in the cell in which this formula is (i.e. here O2)
= VLOOKUP (B2, Sheet2! $ A $ 1: $ B $ 2367,2, FALSE)

you can only insert one "" for different entries:
= IF (table1! B2 = table2! A2; table2! B2; "")

But that's how it should work ... theoretically ... is without a test.

Ps. The formulas have been translated from German with an Excel translator.

Without a file (without sensitive data) it is always difficult to understand exactly what is required.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.