I would like to combine multiple excel files however the data is not in a consistent location (range or cell address) on each sheet . The only way I can tell is by the cell name. For example I need to copy all the data rows below a cell named “Transactions” to a cell named “Total” for 5 columns. The cell location of “Transactions” can very from A23 to A27 and similarly with “Total” The sheet names are consistent. Is this possible?
@kmikkels Welcome to the UIPath Community.
Yes it is possible, First get the cell address from Range lookup activity then perform rest of the tasks