Transfering Data - Multiple Sheets

V

V-Man

I have a userform that requests information from my co-workers and populates worksheet #1. However, I need the data from one cell to be automatically copied to in a cell in 4 other worksheets. How do I link the data in worksheet 1 to automatically populate cells in 4 other worksheets?

Thanks!
 
K

kkknie

Couldn't you just write to the other worksheets when you write to th
first one? Something like:

Sheets("Sheet2").Range("A5").Value = TextBox1.Value
Sheets("Sheet3").Range("C5").Value = TextBox1.Value
Sheets("Sheet4").Range("G5").Value = TextBox1.Value
Sheets("Sheet5").Range("F5").Value = TextBox1.Value

Or am I missing something?
 
J

Jason Morin

Link it to one cell (say Sheet1!A1), and then use =Sheet1!
A1 in the 3 cells on the other worksheets.

HTH
Jason
Atlanta, GA
-----Original Message-----
I have a userform that requests information from my co-
Click to expand...
workers and populates worksheet #1. However, I need the
data from one cell to be automatically copied to in a
cell in 4 other worksheets. How do I link the data in
worksheet 1 to automatically populate cells in 4 other
worksheets?
 
Top