How do I copy the contents of cell a to sheet 2

[byablons]

In my spreadsheet I want to copy the contents of cell L1 sheet 1 to different cell on sheet 2. How would I go about doing that?

 

[Smitty]

Welcome to the Board!

Here's one way (VBA):

Sheets("Sheet1").Range("L1").Copy Sheets("Sheet2").Range("A1")

Or a Formula approach: in your other sheet put =Sheet1!L1

Hope that helps,

Smitty

 

[Zack Barresse]

In my spreadsheet I want to copy the contents of cell L1 sheet 1 to different cell on sheet 2. How would I go about doing that?

select cell on sheet 2, type "="; then click on sheet 1, cell L1, hit enter.

easiest way to link (for me )