VBA: Can you use a button to insert data onto different worksheets?

[Joe94]

The macro I have inserts data onto a sheet, however I would also like this data to be entered onto a different worksheet. I already have the code to open this worksheet, its just the matter of inserting the data onto the 2 different places.
If anyone could help that would be great.
Thanks in advance,
Joe

 

[doofusboy]

Just put the worksheet ahead of the range where the data is to go. Something like this:

Sheets("Sheet1").Range("A1").Value = your_data
Sheets("Sheet2").Range("A1").Value = your_data

That will put the same value into cell A1 of worksheet 1 and worksheet 2