VBA: Using a button to input data onto different worksheets

[Joe94]

Hi,
Currently the button I am using is inputting data onto a sheet on my workbook. I am also using some code to open a different workbook, shown below:

Set wb = Workbooks.Open("H:\6th Form\ICT - Wall\Quotes and Reciept.xlsm")

wb.Sheets("Quotes").Activate

However, I would also like for the data to be inputted onto this sheet, as well as the sheet it is already being inputted onto. Can anybody tell me if this is possible, and to help me out please?

Thanks in advance,
Joe

 

[Norie]

Joe

Perhaps something like this.

wb.Worksheets("Quotes").Range("A1") = "A value"

Though I think I might be missing something here and it's not that simple.