Can I Copy Paste into an Excel comment in a separate Excel file...?

[nofussruss]

I created a form with drop down menus and a database that loads specific data based on your selection. This form is used daily for a different customer and filled out with various information about this days visit. I would like to copy & paste the info only into a comment on my separate Excel master schedule that will serve as a reference for the next service visit.


Is this possible...I can't seem to find a way? Thanks

 

[dan_l]

...........way easier if you do this with access.

 

[dan_l]

I should be less dismissive:


You can extract and manipulate cell comments with relative ease. You can also apply comments to another worksheet with relative ease. You will find the 'details' of applying the information to another workbook to be a little challenging.


Hence why I say Access is a way better option for something like this.

 

[vijaySharma]

Very much possible.


Assuming that you want the data entered from 3-4 different text boxes / drop down to be put as a cell comment.


You can declare a variable to Hold this temp data and use Clipboard to put text and then put it onto a cell comment.


HTH

~Vijay

 

[Hui]

@Nofussruss

When you say Comment do you mean a cell comment or a comment field?

Either way both are possible

 

[nofussruss]

Thanks for all the replies. Hui I want to be able to copy in this case the contents of a page that was filled out and paste the data into a cell comment which is a separate file. Before I created this form for my reporting, all reports were written in a Word.doc and the copy & paste was easy. So now I highlight the cells(page) and attempt to paste it into the comment. Pasting is not an option....