Home

logic to autofill cell based on parameters

%3CLINGO-SUB%20id%3D%22lingo-sub-717432%22%20slang%3D%22en-US%22%3Elogic%20to%20autofill%20cell%20based%20on%20parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717432%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20machine%20data%20log%20that%20I%20am%20manipulating%20to%20extract%20valuable%20data%20from.%26nbsp%3B%20the%20column%20in%20question%20F%2C%20is%20partially%20filled%20with%20the%20data%20i%20need.%26nbsp%3B%20Tab%20%22Work%22%2C%20I%20need%20to%20fill%20the%20empty%20Orange%20cells%20with%20the%20value%20found%20in%20the%20green%20cell.%26nbsp%3B%20the%20issue%20is%20that%20the%20green%20value%20in%20need%20changes%20with%20each%20log%20entry.%26nbsp%3B%20I%20do%20not%20know%20how%20to%20create%20a%20logical%20statement%20of%20macro%20to%20fill%20the%20empty%20cell%20below%20the%20desired%20value%20until%20a%20different%20value%20is%20encountered%2C%20then%20use%20the%20new%20encountered%20value%2C%20so%20on%20and%20so%20forth.%20there%20are%20close%20to%2095%2C000%20lines%20with%2030%20different%20values%20I%20need%20populated%20through%20out%20the%20empty%20orange%20cell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-717432%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
cgroth
Occasional Visitor

I have a machine data log that I am manipulating to extract valuable data from.  the column in question F, is partially filled with the data i need.  Tab "Work", I need to fill the empty Orange cells with the value found in the green cell.  the issue is that the green value in need changes with each log entry.  I do not know how to create a logical statement of macro to fill the empty cell below the desired value until a different value is encountered, then use the new encountered value, so on and so forth. there are close to 95,000 lines with 30 different values I need populated through out the empty orange cell

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies