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

byablons

New Member
Joined
Jan 21, 2004
Messages
4
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?
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
byablons said:
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 :) )
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,734
Members
410,702
Latest member
clizama18
Top