Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
I have created a lattitude/longitude spreadsheet, wherein I search the
lattitudes and longitudes of various cities in order to compute the distance between them. In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste into cells B4 and B5. I ALWAYS must use 'paste speciial' because I need to paste into B4 and B5 the VALUES of the cells in H2 and I2. QUESTIONS: 1. Are there any keyboard strokes I can use to accomplish my copy and paste? and (like CTRL 'V' [except paste special]), 2. Are there any commands I can place in cells B4 and B5 which will copy the 'value' of the 2 cells...H2 and I2? Thank you, FLKulchar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
A simple macro will do the trick
Sub Macro2() Range("b4") = Range("h2").Value Range("b5") = Range("i2").Value End Sub If you don't know anything about macros - do a google search for "Excel macros" -- Wag more, bark less "F. Lawrence Kulchar" wrote: I have created a lattitude/longitude spreadsheet, wherein I search the lattitudes and longitudes of various cities in order to compute the distance between them. In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste into cells B4 and B5. I ALWAYS must use 'paste speciial' because I need to paste into B4 and B5 the VALUES of the cells in H2 and I2. QUESTIONS: 1. Are there any keyboard strokes I can use to accomplish my copy and paste? and (like CTRL 'V' [except paste special]), 2. Are there any commands I can place in cells B4 and B5 which will copy the 'value' of the 2 cells...H2 and I2? Thank you, FLKulchar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Thanks..but, too bad, I know nothing about macros...it is about time I
learned, but I find all the "help" centers not to my liking; perhaps I need to take a class in MACROS! Thanks, FLKulchar "Brad" wrote in message ... A simple macro will do the trick Sub Macro2() Range("b4") = Range("h2").Value Range("b5") = Range("i2").Value End Sub If you don't know anything about macros - do a google search for "Excel macros" -- Wag more, bark less "F. Lawrence Kulchar" wrote: I have created a lattitude/longitude spreadsheet, wherein I search the lattitudes and longitudes of various cities in order to compute the distance between them. In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste into cells B4 and B5. I ALWAYS must use 'paste speciial' because I need to paste into B4 and B5 the VALUES of the cells in H2 and I2. QUESTIONS: 1. Are there any keyboard strokes I can use to accomplish my copy and paste? and (like CTRL 'V' [except paste special]), 2. Are there any commands I can place in cells B4 and B5 which will copy the 'value' of the 2 cells...H2 and I2? Thank you, FLKulchar |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Can I record this macro by typing exactly what you wrote?
Do I need to select one of my cells to do so? "Brad" wrote in message ... A simple macro will do the trick Sub Macro2() Range("b4") = Range("h2").Value Range("b5") = Range("i2").Value End Sub If you don't know anything about macros - do a google search for "Excel macros" -- Wag more, bark less "F. Lawrence Kulchar" wrote: I have created a lattitude/longitude spreadsheet, wherein I search the lattitudes and longitudes of various cities in order to compute the distance between them. In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste into cells B4 and B5. I ALWAYS must use 'paste speciial' because I need to paste into B4 and B5 the VALUES of the cells in H2 and I2. QUESTIONS: 1. Are there any keyboard strokes I can use to accomplish my copy and paste? and (like CTRL 'V' [except paste special]), 2. Are there any commands I can place in cells B4 and B5 which will copy the 'value' of the 2 cells...H2 and I2? Thank you, FLKulchar |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Why are you copying H2 and I2 and pasting to B2 and B5?
In B2 enter =H2 In B5 enter =I2 As H2 and I2 change so shall B2 and B5 Gord Dibben MS Excel MVP On Sat, 26 Jul 2008 08:43:29 -0400, "FLKulchar" wrote: Can I record this macro by typing exactly what you wrote? Do I need to select one of my cells to do so? "Brad" wrote in message ... A simple macro will do the trick Sub Macro2() Range("b4") = Range("h2").Value Range("b5") = Range("i2").Value End Sub If you don't know anything about macros - do a google search for "Excel macros" -- Wag more, bark less "F. Lawrence Kulchar" wrote: I have created a lattitude/longitude spreadsheet, wherein I search the lattitudes and longitudes of various cities in order to compute the distance between them. In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste into cells B4 and B5. I ALWAYS must use 'paste speciial' because I need to paste into B4 and B5 the VALUES of the cells in H2 and I2. QUESTIONS: 1. Are there any keyboard strokes I can use to accomplish my copy and paste? and (like CTRL 'V' [except paste special]), 2. Are there any commands I can place in cells B4 and B5 which will copy the 'value' of the 2 cells...H2 and I2? Thank you, FLKulchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions |