software

I have a worksheet which collects data from several other worksheets in the
same workbook, this data is collected by a user form. The user form then
writes this data to a worksheet, one row at a time I have saved the row and
column value that originally wrote the data to the collecting sheet and the
worksheet name. My problem is, that sometimes I need to return to the
originateing cell to make changes, thought I might be able to use
Cells(Row,Column) or a hyperlink, trouble is I don't know how! I have looked
in the help file but to no avail. Please can anyone help. Many thanks Graham

Worksheet(quot;worksheetnamequot;).cells(row,column)=myval ue

lt;worksheetnamegt;your workshhet name
lt;myvaluegt; data to be saved

Worksheet(quot;worksheetnamequot;).cells(row,column).selec t

will select the cell

HTH
quot;Graham Fquot; wrote:

gt; I have a worksheet which collects data from several other worksheets in the
gt; same workbook, this data is collected by a user form. The user form then
gt; writes this data to a worksheet, one row at a time I have saved the row and
gt; column value that originally wrote the data to the collecting sheet and the
gt; worksheet name. My problem is, that sometimes I need to return to the
gt; originateing cell to make changes, thought I might be able to use
gt; Cells(Row,Column) or a hyperlink, trouble is I don't know how! I have looked
gt; in the help file but to no avail. Please can anyone help. Many thanks Graham

Many thanks toppers, brilliant as usual. Works a treat! Best wishes Graham

quot;Toppersquot; wrote:

gt; Worksheet(quot;worksheetnamequot;).cells(row,column)=myval ue
gt;
gt; lt;worksheetnamegt;your workshhet name
gt; lt;myvaluegt; data to be saved
gt;
gt; Worksheet(quot;worksheetnamequot;).cells(row,column).selec t
gt;
gt; will select the cell
gt;
gt; HTH
gt; quot;Graham Fquot; wrote:
gt;
gt; gt; I have a worksheet which collects data from several other worksheets in the
gt; gt; same workbook, this data is collected by a user form. The user form then
gt; gt; writes this data to a worksheet, one row at a time I have saved the row and
gt; gt; column value that originally wrote the data to the collecting sheet and the
gt; gt; worksheet name. My problem is, that sometimes I need to return to the
gt; gt; originateing cell to make changes, thought I might be able to use
gt; gt; Cells(Row,Column) or a hyperlink, trouble is I don't know how! I have looked
gt; gt; in the help file but to no avail. Please can anyone help. Many thanks Graham