I'll pay $$. (Macro) Copy Table and paste in comment.

[WBabilonia]

Edit: I only need a working code of a macro that copies the visible fields on a table and paste it somewhere else as a comment.

Hi everyone,


I have a problem trying to copy all the filtered data in a Table in one workbook and paste it as a comment in another workbook.

Please Login or Register  to view this content.

The thing is that I can't save all the table's data in a string, so I believe I have to use a multidimensional array or something like that, and honestly, I don't have that amount of knowledge yet. Also, I believe that there is a chance(not necesarily true) that filtering and then selecting the table isn't going to select the visible fields only.

I would be really grateful if someone help me out here with this code(a brief explanation will also be useful), I'm kinda desperate. Thanks.

Edit: I'm willing to pay a beer ($5) via paypal to whoever solve this problem first.

[protonLeah]

Go to the Commercial Services section of this site http://www.excelforum.com/commercial-services/
And read the FAQ on how to solicit paid help.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

[WBabilonia]

I already did.

[FDibbins]

I already did.

Already did what - post in CS or add tags?