Howdy I have a parts list that I have built a search page for. I need the parts list locked out accept for the Qty needs changed from the search page. I can find it, display it, display the location and hyperlink to it. I can also of course calculate the new amount but I need it to change the amount. I can make a macro that will paste info into a know location but the location will change with the search so I need it to paste to the location found in a cell or find the location and then paste it. Please can you help.
[TABLE="width: 252"]
<colgroup><col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3141;"> <col width="28" style="width: 21pt; mso-width-source: userset; mso-width-alt: 977;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2699;"> <col width="14" style="width: 11pt; mso-width-source: userset; mso-width-alt: 488;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3095;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1256;"> <tbody>[TR]
[TD="width: 90, bgcolor: transparent"]search results[/TD]
[TD="width: 28, bgcolor: transparent"]Qty[/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 14, bgcolor: transparent"][/TD]
[TD="width: 89, bgcolor: transparent"][/TD]
[TD="width: 36, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Part# 1234[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"]Removing[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"]Remove from[/TD]
[TD="width: 36, bgcolor: transparent"]$E$6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]new Qty[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 36, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 4"]Parts list[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 36, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Part# 1234[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Current Qty[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 252"]
<colgroup><col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3141;"> <col width="28" style="width: 21pt; mso-width-source: userset; mso-width-alt: 977;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2699;"> <col width="14" style="width: 11pt; mso-width-source: userset; mso-width-alt: 488;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3095;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1256;"> <tbody>[TR]
[TD="width: 90, bgcolor: transparent"]search results[/TD]
[TD="width: 28, bgcolor: transparent"]Qty[/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 14, bgcolor: transparent"][/TD]
[TD="width: 89, bgcolor: transparent"][/TD]
[TD="width: 36, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Part# 1234[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"]Removing[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"]Remove from[/TD]
[TD="width: 36, bgcolor: transparent"]$E$6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]new Qty[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 36, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 4"]Parts list[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 36, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Part# 1234[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Current Qty[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]