collection

[mounika]

hi All,
i just want copy the data from sheet1 to sheet2 same workbook

im using copy/paste range action

it wasnt paste the data from shee2 to 1

any one rly me
source range:A1:A20
Destrange:A1:A8

 

[mohan12]

use write collection option

 

[mounika]

i dont want to store this data to collection...just copying data from sheet2 to sheet1 .....in one workbook
sory i named it as coll above...
thnk for ur rly mohan12

 

[RPAPJ]

if you want to paste only from A1:A8 when you have data from A1:A20, why don't you just give range in source as A1:A8 so only those values will be pasted. Not sure if this is helpful to you but putting my thought here.

 

[mounika]

thank you RPAPJ

 

[VJR]

Hi mounika,

Choose the Source Range as per your requirement - A1:A20 OR A1:A8

You can also set the Destination Range parameter simply as A1 and it will automatically paste whatever data is in the Source Range starting from cell A1.

 

[mounika]

k.its worked VJR

Thankyouu