| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
I have a name on sheet1 in cell a1 and when i click a button i want the
contents of a1 pasting to f2 on sheet 2 Thank You for your help in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
Here is the code...
Sheets("Sheet2").Range("F2").value = Sheets("Sheet1").Range("A1").Value Do you need help creating a button and adding the code to the button? -- HTH... Jim Thomlinson "cityfc" wrote: I have a name on sheet1 in cell a1 and when i click a button i want the contents of a1 pasting to f2 on sheet 2 Thank You for your help in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
THAT WORKS A TREAT THANKYOU SO MUCH I HAVE BEEN TRYING DIFFERENT WAYS WITHOUT
SUCCESS FOR AGES COULD I BE CHEEKY AND ASK FOR A BIT MORE HELP NOW THAT THE CELLS CONTENTS HAVE MOVED SHEETS HOW DO I GET IT TO AUTOMATICALLY INSERT "VACANCY" IN THE CELL ON SHEET 1 A1 THANKS AGAIN "Jim Thomlinson" wrote: Here is the code... Sheets("Sheet2").Range("F2").value = Sheets("Sheet1").Range("A1").Value Do you need help creating a button and adding the code to the button? -- HTH... Jim Thomlinson "cityfc" wrote: I have a name on sheet1 in cell a1 and when i click a button i want the contents of a1 pasting to f2 on sheet 2 Thank You for your help in advance. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
First of all, turn off you damn CAPS LOCK key. Typing in caps is
considered shouting and thus rude, and is hard to read. I can't imagine what would possess someone to type in all caps. Sheets("Sheet1").Range("A1").Value = "Vacancy" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "cityfc" wrote in message ... THAT WORKS A TREAT THANKYOU SO MUCH I HAVE BEEN TRYING DIFFERENT WAYS WITHOUT SUCCESS FOR AGES COULD I BE CHEEKY AND ASK FOR A BIT MORE HELP NOW THAT THE CELLS CONTENTS HAVE MOVED SHEETS HOW DO I GET IT TO AUTOMATICALLY INSERT "VACANCY" IN THE CELL ON SHEET 1 A1 THANKS AGAIN "Jim Thomlinson" wrote: Here is the code... Sheets("Sheet2").Range("F2").value = Sheets("Sheet1").Range("A1").Value Do you need help creating a button and adding the code to the button? -- HTH... Jim Thomlinson "cityfc" wrote: I have a name on sheet1 in cell a1 and when i click a button i want the contents of a1 pasting to f2 on sheet 2 Thank You for your help in advance. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
thanks for all your help
sorry just typed away and sent to late to realise "Chip Pearson" wrote: First of all, turn off you damn CAPS LOCK key. Typing in caps is considered shouting and thus rude, and is hard to read. I can't imagine what would possess someone to type in all caps. Sheets("Sheet1").Range("A1").Value = "Vacancy" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "cityfc" wrote in message ... THAT WORKS A TREAT THANKYOU SO MUCH I HAVE BEEN TRYING DIFFERENT WAYS WITHOUT SUCCESS FOR AGES COULD I BE CHEEKY AND ASK FOR A BIT MORE HELP NOW THAT THE CELLS CONTENTS HAVE MOVED SHEETS HOW DO I GET IT TO AUTOMATICALLY INSERT "VACANCY" IN THE CELL ON SHEET 1 A1 THANKS AGAIN "Jim Thomlinson" wrote: Here is the code... Sheets("Sheet2").Range("F2").value = Sheets("Sheet1").Range("A1").Value Do you need help creating a button and adding the code to the button? -- HTH... Jim Thomlinson "cityfc" wrote: I have a name on sheet1 in cell a1 and when i click a button i want the contents of a1 pasting to f2 on sheet 2 Thank You for your help in advance. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
With Sheets("Sheet1").Range("A1")
Sheets("Sheet2").Range("F2").Value = .Value .Value = "Vacancy" End With -- Regards, Tom Ogilvy "cityfc" wrote in message ... THAT WORKS A TREAT THANKYOU SO MUCH I HAVE BEEN TRYING DIFFERENT WAYS WITHOUT SUCCESS FOR AGES COULD I BE CHEEKY AND ASK FOR A BIT MORE HELP NOW THAT THE CELLS CONTENTS HAVE MOVED SHEETS HOW DO I GET IT TO AUTOMATICALLY INSERT "VACANCY" IN THE CELL ON SHEET 1 A1 THANKS AGAIN "Jim Thomlinson" wrote: Here is the code... Sheets("Sheet2").Range("F2").value = Sheets("Sheet1").Range("A1").Value Do you need help creating a button and adding the code to the button? -- HTH... Jim Thomlinson "cityfc" wrote: I have a name on sheet1 in cell a1 and when i click a button i want the contents of a1 pasting to f2 on sheet 2 Thank You for your help in advance. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
thanks for everones help
"Tom Ogilvy" wrote: With Sheets("Sheet1").Range("A1") Sheets("Sheet2").Range("F2").Value = .Value .Value = "Vacancy" End With -- Regards, Tom Ogilvy "cityfc" wrote in message ... THAT WORKS A TREAT THANKYOU SO MUCH I HAVE BEEN TRYING DIFFERENT WAYS WITHOUT SUCCESS FOR AGES COULD I BE CHEEKY AND ASK FOR A BIT MORE HELP NOW THAT THE CELLS CONTENTS HAVE MOVED SHEETS HOW DO I GET IT TO AUTOMATICALLY INSERT "VACANCY" IN THE CELL ON SHEET 1 A1 THANKS AGAIN "Jim Thomlinson" wrote: Here is the code... Sheets("Sheet2").Range("F2").value = Sheets("Sheet1").Range("A1").Value Do you need help creating a button and adding the code to the button? -- HTH... Jim Thomlinson "cityfc" wrote: I have a name on sheet1 in cell a1 and when i click a button i want the contents of a1 pasting to f2 on sheet 2 Thank You for your help in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
| Copy Paste to another sheet | Excel Worksheet Functions | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
| automatic copy and paste from sheet to sheet in a workbook | Excel Programming | |||
Linear Mode
