Hello,
First post here,
I am a bit of a newbie with Excel / VBA but very passionate about this since a lot of stress can be relieved and time saved, but all the information I can find by extensive google and youtube searches doesnt seem to nail it..... Please help
My occupation and that of my colleagues is to read customer queries, analyse them and answer to them accordingly. Some answers need to have specific information pasted into specific fields, corresponding to data already populated in an excel sheet.
I can't find any instructions on how to order the excel information from cell "xy" to be pasted into the field "Address 1", while conserving pre-existing formatting. Also, the ability to populate a table cell within word in the same way. Then paste the Excel data from the next cell on the same row, etc, so each row corresponds to a template being completely filled out.
Around 30 hours a week for the whole team, which can't keep up with the work, could be saved with something like this. Maybe a wizard to populate the excel sheet while browsing through the letter and third party software would be ideal, but that's for another time. Please help with any insight and/or suggestions.
Yours truly,
Kirov
First post here,
I am a bit of a newbie with Excel / VBA but very passionate about this since a lot of stress can be relieved and time saved, but all the information I can find by extensive google and youtube searches doesnt seem to nail it..... Please help
My occupation and that of my colleagues is to read customer queries, analyse them and answer to them accordingly. Some answers need to have specific information pasted into specific fields, corresponding to data already populated in an excel sheet.
I can't find any instructions on how to order the excel information from cell "xy" to be pasted into the field "Address 1", while conserving pre-existing formatting. Also, the ability to populate a table cell within word in the same way. Then paste the Excel data from the next cell on the same row, etc, so each row corresponds to a template being completely filled out.
Around 30 hours a week for the whole team, which can't keep up with the work, could be saved with something like this. Maybe a wizard to populate the excel sheet while browsing through the letter and third party software would be ideal, but that's for another time. Please help with any insight and/or suggestions.
Yours truly,
Kirov
