I have this form I send out and have personnel fill out and send back to me. Is it possible in VBA to copy all cells that are filled in and have them populate a table in a spreadsheet. I get 10 to 15 forms a day. Coping and pasting is a pain.
Is this possible in excel?
Thanks for looking at this.
Attached a copy of form.
|Reason for Return||Model #|
|Installation Date||Serial Number|
|Mfg Date Code||Customer Information|
|RGA (return good authorization||Serial Number Tag|
|Vendor Supplied Tag||None|
|On Site Inspection|
|Return To Vendor|
|Return To Representative|
|Fax Vendor Supplied Form||Handling Charges May Apply - See Contact|
|Shipping Charges May Apply - See Contact|
Excel tables to the web >> Excel Jeanie HTML 4