Add New Column And Fill Series

%3CLINGO-SUB%20id%3D%22lingo-sub-2689798%22%20slang%3D%22en-US%22%3EAdd%20New%20Column%20And%20Fill%20Series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2689798%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPresently%20I%20am%20working%20on%20a%20VBA%20project%20and%20need%20your%20help%20in%20it.%20Below%20is%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EProblem%20Statement%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Edescribed%20in%20a%20chronological%20manner%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20I%20have%20to%20work%20with%20a%20very%20large%20data%20set.%20Columns%20in%20this%20data%20set%20range%20from%20250%20to%20280%20Columns%20but%20number%20of%20columns%20is%20never%20fixed.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EI%20have%20to%20get%20to%20the%20last%20column%20%3D%3D%26gt%3B%20add%20multiple%20new%20column%20at%20the%20end%20of%20the%20dataset%20%3D%3D%26gt%3B%20and%20name%20the%20columns%20like%20%22checklist%201%22%2C%22checklist%202%22%2C%20%22checklist%203%22.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Apply%20Criteria%20specific%20filters%20in%20the%20already%20existing%20data%20set%20in%20multiple%20columns.%20(%3CSTRONG%3EThis%20part%20of%20the%20project%20is%20already%20done%3C%2FSTRONG%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20As%20per%20the%20filters%20applied%20in%20the%20existing%20data%20set%2C%20data%20needs%20to%20be%20auto%20filled%20in%20the%20newly%20added%20columns%20as%20created%20in%20step%201.%20(%3CSTRONG%3EFor%20Example%20%3A-%20after%20applying%20filters%20in%20the%20existing%20data%2C%20row%20count%20is%20289.%20Now%20those%20289%20rows%20will%20be%20auto%20filled%20in%20column%20%22checklist%201%22%20with%20a%20text%20provided%20in%20the%20macro%20itself.%20row%20filler%20text%20can%20be%20anything%20and%20has%20to%20be%20set%20in%20the%20macro%3C%2FSTRONG%3E)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2689798%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello All,

 

Presently I am working on a VBA project and need your help in it. Below is the Problem Statement described in a chronological manner:-

 

1. I have to work with a very large data set. Columns in this data set range from 250 to 280 Columns but number of columns is never fixed. I have to get to the last column ==> add multiple new column at the end of the dataset ==> and name the columns like "checklist 1","checklist 2", "checklist 3".

 

2. Apply Criteria specific filters in the already existing data set in multiple columns. (This part of the project is already done)

 

3. As per the filters applied in the existing data set, data needs to be auto filled in the newly added columns as created in step 1. (For Example :- after applying filters in the existing data, row count is 289. Now those 289 rows will be auto filled in column "checklist 1" with a text provided in the macro itself. row filler text can be anything and has to be set in the macro)

0 Replies