Excel tabs Automation to overcome the manual efforts while applying formulas in Cells

[ppr (Peter Preuss)]

@Bhupesh_Gupta
have a look here for initial block parsing:

Dynamic Extraction of Data Blocks from Excel

@NAJAA_BAZILAH I worked out a sample for you showcasing on how an extraction could be done. With some alignments I made the implementation flexible and stressed it with this as well: [grafik] Extraction was possible for your and my tables. Constraints: no overlapping data within the cols. Does mean we can detect blocks and if a block starts on Column B, then no Block will start on Column C (Overlappings) Find XAML here: NAJAA_BAZILAH.xaml (16.0 KB) Excel Here: Book2_PPR.xlsx (12.6 KB…

extracting the different blocks can help to pull out the different portions needed in output 4