I need help on Copy/Move validated/formatted sheets to another workbook dynamically with huge data. I’m able to copy sheet from one workbook to another but the problem is, it’s getting added once only, meaning, if Sheet1 is added once then next time it’s throwing an error - saying that Sheet1 already exists.
My requirement is, I need to add the Sheet1 to another workbook (Monthly Report) on daily basis, where it should add like: - Sheet1, Sheet1(1), Sheet1(2), Sheet1(3)…Sheet1(n).
I don’t want to use build data table or read range activities since I’m getting huge data in lacs on daily basis, these activities are taking too long time.
Use the Get Workbook Sheets activity to retrieve the sheet names from the destination workbook. If any of the sheet names contain “Sheet1”, the next sheet should be named “Sheet1(1)”, followed by “Sheet1(2)” for the subsequent workbook, and so on.
Oh no, actually there is only one sheet called “Hoja1” in Spanish in destination workbook. Bot should add the Sheet1 from source to destination workbook. so, while adding Sheet1 to destination workbook it should be adding like Sheet1, next day Sheet1(1), next day Sheet1(2)…
2.In your code use Get Asset activity to get the sheetcount
3.In Copy Paste Range activity pass the SheetCount variable
4.After the process use Set Asset activity to update the sheetcount
