i have a windows form with a datagrid, and i want the user to be able to copy and paste the data i am going to perform calculations on, into the grid in a certain column. For simpilicity, we can assume that they have copied the correct numerical values to the clipboard from excel, and they have selected the correct cell in the correct column in the datagrid to paste it into. I would also like one value per cell as found in excel.

so in lehmann's terms i would like the procedure to be:

if the clipboard contains data

for each piece of data/value in the clipboard

copy value into the cell

go to the next row below and copy next piece of data etc.

Any help would be greatly appreciated in pointing me in the right direction

Thanks