Move from one sheet to another sheert in same excel sheet

[priya_joshi_thaneti (priya joshi)]

Hi all ,

I would like to move from one sheet of the excel file (ex:sheet 1) to another sheet (sheet 2) in the excel file and save the excel sheet , such that If I open the excel file , I should be looking at the sheet 2 .

Can anyone please help me with this .

Thank you !
priya

[ranjith]

@priya_joshi_thaneti

If there is only one sheet in the workbook,then try the below

Read the data from sheet1 > delete the file > write the copied data to sheet2

Check this xaml file . sample.xaml (5.7 KB)

Regards,
Ranjith.

[abhyudai_munna (Deadpool)]

Use send Hotkey Activity(Shift+F11) which will create a new sheet, Then you can use cntrl+s to save the Excel.
Whenever you open the excel it will point to the newly created sheet.

I hope this helps

[aksh1yadav (AKSHAY YADAV)]

Hey @priya_joshi_thaneti

@priya_joshi_thaneti

I would like to move from one sheet of the excel file (ex:sheet 1) to another sheet (sheet 2) in the excel file and save the excel sheet , such that If I open the excel file , I should be looking at the sheet 2 .

Can anyone please help me with this .

Let me Clarify - you want to activate any sheet for example sheet 2 then next time you wanna open excel it should show Sheet 2 Activated? am i correct?

Regards…!!
Aksh

[aksh1yadav (AKSHAY YADAV)]

@aksh1yadav

Let me Clarify - you want to activate any sheet for example sheet 2 then next time you wanna open excel it should show Sheet 2 Activated? am i correct?

Well @priya_joshi_thaneti if you will confirm den i have a solution,

Regards…!!
Aksh

[priya_joshi_thaneti (priya joshi)]

yes @aksh1yadav,

here I have sheet 1 named as “Template Pivot”
and sheet 2 named as “Template”
and sheet 3 as “Changes”

I would like to move from sheet 2 to sheet 1 and save the excel file , so that if I open the excel file I would be looking at sheet 1 directly

and also I dont want to delete any sheets .

[abhyudai_munna (Deadpool)]

Switch Between Worksheets in Excel . So in order to move through sheets or tabs in an Excel workbook using the keyboard, simply press and hold CTRL and then press the PgUp or PgDn buttons to move from right-to-left or left-to-right! That’s it!

Try to automate it using “Send Hotkey” Activity.

[aksh1yadav (AKSHAY YADAV)]

Hey @priya_joshi_thaneti

@priya_joshi_thaneti

here I have sheet 1 named as “Template Pivot”
and sheet 2 named as “Template”
and sheet 3 as “Changes”

I would like to move from sheet 2 to sheet 1 and save the excel file , so that if I open the excel file I would be looking at sheet 1 directly

and also I dont want to delete any sheets .

No Hot keys and Ui Automation Included

Here we go - ActivateSheet.zip (9.9 KB)

Regards…!!
Aksh

Regards…!!
Aksh

[priya_joshi_thaneti (priya joshi)]

Hi @aksh1yadav

Im unable to open the file … could you please check and let me know .

[aksh1yadav (AKSHAY YADAV)]

Depends on version i am musing Latest Beta Relase…!!

and if you cant change version then follow image

it is So simple

Regards…!!
Aksh

[priya_joshi_thaneti (priya joshi)]

Hi @aksh1yadav

can we pass the sheet name directly in the select range ?

[aksh1yadav (AKSHAY YADAV)]

Yes both things we can do the thing is having advantage in some cases where just sheet order matters instead of their names.

Regards…!!
Aksh

[priya_joshi_thaneti (priya joshi)]

Thanks a lot akash

can you please look into this issue as well

Compress Pivot table

Hi Everyone ! I have a query , can we compress the Pivot table while sending the mail ? below is the original file .(image 1) [image] This is how I want to send the mail [image] can anyone share me the xaml file if possible P.s : the values are different(the difference of digits can be ignored )