| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updated sheet content is not copy pasting from sheet1 to sheet2
Hi all,
I wrote VB amcro which is copy pasting content of sheet from sheet1 to sheet2. But when i update any cell in source sheet manually, still it paste the old value into destination sheet. I dont know what is going wrong from my end. Kindly help me in this regards. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Updated sheet content is not copy pasting from sheet1 to sheet2
Arun, check the sheet tab to see whether both the sheets are grouped
together. If so Right click on the sheet tab and 'ungroup sheets' If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi all, I wrote VB amcro which is copy pasting content of sheet from sheet1 to sheet2. But when i update any cell in source sheet manually, still it paste the old value into destination sheet. I dont know what is going wrong from my end. Kindly help me in this regards. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Updated sheet content is not copy pasting from sheet1 to sheet2
Post the code.
Gord Dibben MS Excel MVP On Mon, 25 May 2009 00:30:00 -0700, arun wrote: Hi all, I wrote VB amcro which is copy pasting content of sheet from sheet1 to sheet2. But when i update any cell in source sheet manually, still it paste the old value into destination sheet. I dont know what is going wrong from my end. Kindly help me in this regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| Excel Challenge: Copy and pasting sheet1 to sheet2 | Excel Worksheet Functions | |||
| A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| Copy result from sheet1 to sheet2 | Excel Discussion (Misc queries) | |||
Linear Mode
