I want to extract cell data from an open Excel Spreadsheet to an open Word Document by means of a Macro Shortcut Key. The section in the word document I need to paste data to, is a typical three line format for NAME, ADDRESS, CITY/STATE/ZIP. The cells in the Spreadsheet I need to copy from are the first five in any given row. For instance A1 = John Smith, B1 = 123 Somewhere Lane, C1 = anywhereville, D1 = NJ, E1 = 01234. There are subsequent cells afterwards with additional data, but I don't need them. I want to be able to simply click on the first cell of whatever name I'm working on and have the macro copy that cell and the next four, then paste that (text only - no format) into their appropriate places in the section of the word document I mentioned earlier. This might seem laughably easy to some, but I've looked high and low for the right way to write this code, but to no avail, I'm at an impass. Any help would be greatly appreciated.
Find latest posts