Home

Need Help creating a dynamic yearly report

%3CLINGO-SUB%20id%3D%22lingo-sub-363987%22%20slang%3D%22en-US%22%3ENeed%20Help%20creating%20a%20dynamic%20yearly%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363987%22%20slang%3D%22en-US%22%3E%3CP%3EI%20run%20a%20yearly%20report%20%2C%20and%20the%20information%20comes%20from%20different%20workbooks%20that%20are%20created%20on%20a%20weely%20bases%2C%20what%20I%20do%20basically%20is%20use%20Hlookup%20and%20then%20having%20to%20change%20the%20date%20of%20the%20workbook%20and%20sheet%20name%20manaully%2C%20it's%20very%20time%20consuming%20i%20need%20help%20to%20make%20it%20dynamic.%20I%20have%20tried%20to%20use%20indirect%20with%20no%20success%20%2C%26nbsp%3B%20i%20made%20a%20video%20in%20order%20to%20try%20to%20explain%20what%20i%20do%20on%20regular%20bases.%3C%2FP%3E%3CP%3EThanks%20a%20lot%20in%20advance%20for%20all%20the%20help%20I%20can%20get%26nbsp%3B%20to%20make%20this%20possible%20.%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Excel%20Workbook%22%20href%3D%22https%3A%2F%2F1drv.ms%2Fv%2Fs!AlsYRq2Fsn_QgZ8ueKeVNrB1FkAaRg%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eexcel%20workbook%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-363987%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
cvilla714
Frequent Visitor

I run a yearly report , and the information comes from different workbooks that are created on a weely bases, what I do basically is use Hlookup and then having to change the date of the workbook and sheet name manaully, it's very time consuming i need help to make it dynamic. I have tried to use indirect with no success ,  i made a video in order to try to explain what i do on regular bases.

Thanks a lot in advance for all the help I can get  to make this possible .

excel workbook

 

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies