ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   auto copy and paste to another workbook by using specific titles (https://www.excelbanter.com/excel-programming/442111-auto-copy-paste-another-workbook-using-specific-titles.html)

confused inquiror

auto copy and paste to another workbook by using specific titles
 
I am trying to get information from a row that contains a specific title to
be transferred to another workbook automatically. I also need to know how to
do this with the cells not matching up.

Rich Locus

auto copy and paste to another workbook by using specific titles
 
Hello:

Your question is vague. If you mean that when someone opens the
spreadsheet, the contents of a row with a certain title is copied to another
spreadsheet, then you can use the Auto_Open() event to search for the row,
open the target spreadsheet, insert it, and then close the spreadsheet,
saving the contents.

Again, I may not be addressing your question, but again, it very general.
--
Rich Locus
Logicwurks, LLC


"confused inquiror" wrote:

I am trying to get information from a row that contains a specific title to
be transferred to another workbook automatically. I also need to know how to
do this with the cells not matching up.



All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com