hi Friends,
i have a repeated kind of work doing in a excel file, where i will explain the manual steps below,
actually i have 4 set of datas(highlighted in green) in column wise & each contains the subtotal(Highlighted in Red)
at the right corner of each set of datas,based on Availability of this Subtotal, we should copy required datas.
could someone please help me to provide the VBA to do the same, it will be a great help to me & reduce my workload
STEPS:
1.Open the workbook & goto cell range AC2, Here the values in cell range(AC2, W2, O2, H2) are the subtotals
2.Goto AC2 & check for numerical values, IF Available then i m pressing CTRL+DOWN, then SHIFT+1 step UP then SHIFT+3 cells LEFT
so here my required data is selected & now it can be pasted in AE2.
3.IF AC2 subtotal field is Blank / #NAME?, then it should skip that set of data & check for next set of data.
the same above process has to be done till the end of sheet.
for better understanding i have attached the sample sheet & highlighted the output values in Blue at the end.
kindly request some expert to reduce my manual workloads.
Thanks in Advance.
Bookmarks