I want to read this excel there are two tables one is for sales and one is for stokes i want to read these two tables bt the range is not fixed

bharne 3.xlsx (59.0 KB)
Sales table is ending in K col and Somestimes in L Col…How can i achieve this ? Please help

@aparna3010,

You can achieve by checking cell value of L2. if cell L2 value is Amount
give range from A:L otherwise A:K
// Take read cell activity to get value of L2 cell and will return string Amount
// take if activity
If string = “Amount”{
// take read range and provide range as A:L
}Else{
// take read range and provide range as A:K
}

1 Like