Paste Special

[F. Lawrence Kulchar]

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

 

[Brad]

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"

 

[FLKulchar]

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

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

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

 

[FLKulchar]

Can I record this macro by typing exactly what you wrote?

Do I need to select one of my cells to do so?

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

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

 

[Gord Dibben]

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

Can I record this macro by typing exactly what you wrote?

Do I need to select one of my cells to do so?

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

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