Clear sheet

Help Studio
,
1

Hi
i have 2 excel, i want to copy data from one excel & paste in second excel have 5 sheet same data Paste then how i do it.
before paste same data in second excel of 5 sheet like Sheet A, Sheet B, Sheet C, Sheet D

clear or delete all data from Sheet A,B,C,D

How i do it?

2

Hi @yogitagaikwad2206

Use Clear Sheet activity

image

Regards,

3

in same excel how clear data from 5 sheets

4

Hi @yogitagaikwad2206

5

@yogitagaikwad2206

Simply try below

Array_SheetNames={"Sheet1","Sheet2","Sheet3","Sheet4","Sheet5"}

image
image828×1184 47.3 KB

Sequence8.xaml (11.3 KB)

Regards,

6

@yogitagaikwad2206

Use Macros

Sub ClearSheet()
Sheets("SheetA").Cells.Clear
Sheets("SheetB").Cells.Clear
Sheets("SheetC").Cells.Clear
Sheets("SheetD").Cells.Clear
End Sub

image
image556×645 21.7 KB

7

now i want to copy data from one sheet with range & paste in other excel which has 5 sheet
same data paste in all 5 sheet how i do it

8

@yogitagaikwad2206

Better to create new topic as it is different topic, i will help you

Regards,

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.