Lets say we have the following on one worksheet (lets call it data):

Supplier No Discount Comment1
12345 5%
67890 10%

On the second worksheet (called info) I will have a vlookup so the use
enters the suplier number and the discount and comments field ar
displayed.

I will have another comments box on the info sheet where users ca
enter comments if the comments field (on the data worksheet) is blank
hence being blank from the lookup.


The user would then click a button to enter the data. This data tha
the user entered would then be copied and pasted to the respectiv
comment field on the data tab.

The reason for doing it like this is that there are over 700 supplier
on any given weekly report and it currently takes a long time to sor
through the supplier data fields.

I came up with this macro: this will always paste the data into cel
d2. However I will need this data to be entered into the comments fiel
for that respective supplier. I thought I could have a formula tha
displays the cell location of where the data should be pasted and us
that in the macro??

Range("B8").Select (This is the user input field)
Selection.Copy
Sheets("Data").Select
Range("d2")Select (Can I put a cell location here that has th
location of where to paste the data)
ActiveSheet.Paste

Many many thanks

--
Message posted from http://www.ExcelForum.com