Data from Pivot table to other sheets - Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-1273857%22%20slang%3D%22en-US%22%3EData%20from%20Pivot%20table%20to%20other%20sheets%20-%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1273857%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%40Patrick2788%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20data%20in%20Pivot%20table%20for%20running%20dates%20of%20stock%20prices%20with%20some%20calculations%2C%20the%20data%20gets%20refreshed%20on%20daily%20basis.%20There%20are%20multiple%20sheets%20for%20each%20stock%20name.%20I%20need%20a%20macro%20for%20data%20to%20automatically%20come%20from%20pivot%20data%20to%20respective%20sheets%20at%20the%20end%20of%20each%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20file%2C%20data%20from%20April%201%2C%202020%20from%20Pivot%20should%20go%20respective%20sheets%20of%20stock%20name%20in%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EData%20from%20%22Pivot%22%20sheet%20-%20Column%20A%20to%20H%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EFilter%20stock%20%3D%22NIFTY%22%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EData%20should%20go%20to%20sheet%20%22NIFTY%22%20-%20Column%20B%20to%20I%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EFurther%20from%20Column%20J%20to%20AB%20it%20is%20auto%20calculations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20same%20process%20should%20go%20on%20to%20other%20sheets%2C%20currently%20I%20have%20about%2016%20sheets%20for%20pilot%2C%20I%20need%20to%20have%20150%20sheets%20finally.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20%2F%20guidance%20for%20macro%20will%20be%20highly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20many%20similar%20files%2C%20need%20to%20learn%20to%20record%20macros%20so%20daily%20data%20can%20go%20into%20respective%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EVinay%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1273857%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi

@Patrick2788 

 

I have data in Pivot table for running dates of stock prices with some calculations, the data gets refreshed on daily basis. There are multiple sheets for each stock name. I need a macro for data to automatically come from pivot data to respective sheets at the end of each day,

 

In the attached file, data from April 1, 2020 from Pivot should go respective sheets of stock name in the file.

 

Data from "Pivot" sheet - Column A to H

Filter stock ="NIFTY"

Data should go to sheet "NIFTY" - Column B to I

Further from Column J to AB it is auto calculations.

 

And same process should go on to other sheets, currently I have about 16 sheets for pilot, I need to have 150 sheets finally.

 

Any help / guidance for macro will be highly appreciated.

 

I have many similar files, need to learn to record macros so daily data can go into respective files.

 

Thanks

Vinay

0 Replies