 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007push rather than pull cell data.
Is it possible with excel to push data from cells to another sheet in same excel file rather than pull it from the cells you want populated each time cell data is changed. Thanks for any help with this. Maybe you could use a macro. > Is it possible with excel to push data from cells to another sheet in same > excel file rather than pull it from the cells you want populated each time > cell data is changed. > > Thanks for any help with this.  SignatureDave Peterson sheets("sourcesht").range("a2:a22").copy sheets("destsht").range("a2") or (note ranges must be the same size) sheets("destsht").range("a2:a22").value= _ sheets("sourcesht").range("a4:a24").value SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Is it possible with excel to push data from cells to another sheet in same > excel file rather than pull it from the cells you want populated each time > cell data is changed. > > Thanks for any help with this. Maybe linking cells would work for you. Enter =Sheet1!A1 in any cell on Sheet2 and that cell will update when Sheet1 A1 is changed. Gord Dibben MS Excel MVP >Is it possible with excel to push data from cells to another sheet in same >excel file rather than pull it from the cells you want populated each time >cell data is changed. > >Thanks for any help with this. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.