Home

Macro to insert rows

%3CLINGO-SUB%20id%3D%22lingo-sub-279075%22%20slang%3D%22en-US%22%3EMacro%20to%20insert%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279075%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindly%20help%20me%20to%20automatically%20use%20macros%20to%20insert%20alternative%20rows%20%3B%20e.g.%20I%20have%20the%20sales%20data%20for%20a%20set%20of%20customers%20for%202017%20and%202018%20side%20by%20side%20-%20from%20Jan%20to%20Oct%3B%20but%20I%20need%202017%20in%20one%20row%20Jan%20to%20Oct%20and%20below%20in%20the%20next%20row%202018%20data%20should%20be%20displayed%20from%20Jan%20to%20Oct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-279075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
anoo_perumal
Occasional Visitor

Dear all,

 

Kindly help me to automatically use macros to insert alternative rows ; e.g. I have the sales data for a set of customers for 2017 and 2018 side by side - from Jan to Oct; but I need 2017 in one row Jan to Oct and below in the next row 2018 data should be displayed from Jan to Oct.

 

thanks

 

Related Conversations