Hi All
I have two worksheets 'Dashboard' and 'Data' in the same workbook. I need to extract specific text from Data into Dashboard. The number of rows in Data are unknown.
Let the unknown row as x, column as number (e.g. column D =4)
If Data!(x,4) = "3", then to extract the data below into Dashboard from row 24 and onwards:
Dashboard!B24.value = Data!(x,1)
Dashboard!C24.value = Data!(x,2)
Dashboard!G24.value = Data!(x,5)
Dashboard!AA24.value = Data!(x, 6)
Dashboard!AC24.value = Data!(x, 7)
The the next row of data will be in row 25 of Dashboard and onwards.
Please could anyone give me an idea how to create this macro? Many thanks.
I have two worksheets 'Dashboard' and 'Data' in the same workbook. I need to extract specific text from Data into Dashboard. The number of rows in Data are unknown.
Let the unknown row as x, column as number (e.g. column D =4)
If Data!(x,4) = "3", then to extract the data below into Dashboard from row 24 and onwards:
Dashboard!B24.value = Data!(x,1)
Dashboard!C24.value = Data!(x,2)
Dashboard!G24.value = Data!(x,5)
Dashboard!AA24.value = Data!(x, 6)
Dashboard!AC24.value = Data!(x, 7)
The the next row of data will be in row 25 of Dashboard and onwards.
Please could anyone give me an idea how to create this macro? Many thanks.
Last edited: