Dear Experts,
I need some help in writing a code to do the following steps in a worksheet change event on my sheet 1
Sheet 1 is input and summary sheet, Sheet2 is (Data set 1) & Sheet 3 is Data set 2 Starting from Sheet 1, Cell B1 has a dropdown list upon selecting an item name value in Cell C1 (Value from a match formula) and D1 (Value from a count if formula) changes. Currently its showing C1 = 312 & D1 =28
What I want from my worksheet function is:
1.Clear the contents of cell a7:m74
2.Go to row 312(number comes from cell C1) on Sheet2 and then copy 13 columns(Fixed) and copy 28 Rows (Number comes from cell D1) and paste it in Cell A7 onwards
3.Above step will also populate cell F1 with minimum value of column K and maximum value of column L
4.Then it should go to sheet 3 Column A and find all the values between Min (From Cell F1) and maximum (From Cell G1) and copy and paste all 13 columns starting from column P7
P.S. Data(Numbers) in column A sheet three is sorted in ascending order.
Best Regards/VKS
Bookmarks