Originally Posted by
SirSFZ
i have a table in excel that has the headers in column A, and each subsequent column is another record. (unfortunatly, the person who created and uses this sheet wants it set up like that.)
i need to use this spreadsheet as the data source for a mail merge. what i did was paste special into a new sheet with the transpose option checked.
is there a way for me to set up soem formula so that when new information is entered/edited in the first sheet, the second one updates as well? i tried using the = function, but that is not fillable across the sheet. any suggestions?
Bookmarks