 |
 | 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 / Worksheet Functions / February 2008Data Extraction (Excel 97)
I'm trying to find a way for one column in a seperate spreadsheet to be automatically popualated by the text that is input onto another spreadsheet. I am not taking data from one single spreadsheet but taking data from several (100+) spreadsheets setup for individual users. All of the user spreadsheets are the same and the data I need to tak is a free format text entry that isn't mandatory. Can anyone suggest a way to pull this information from the user spreadsheets into another spreadsheet, it would need to ignore any blank information and not overwrite information taken from the other spreadsheets. I'm using MS Excel 97. While I have little knowlegde of VB i am willing to conceed that this might only be possible via VB. How the sheet is setup : Column A | Date | Time | Query | Save | Scheme | Reason | Comments <-- Free format Data rows are row 3 to 1000 All suggestions are welcomed. Hi Phendrena Try http://www.rondebruin.nl/merge.htm See also the code pages on the bottom  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > I'm trying to find a way for one column in a seperate spreadsheet to be > automatically popualated by the text that is input onto another spreadsheet. [quoted text clipped - 17 lines] > > All suggestions are welcomed. thanks for the reply. Is there a way to this without using an add-in as i'm on a corporate network and as such don't have the facility to use add-ins. I'll have a look at the add-ins from home however! Thanks, > Hi Phendrena > [quoted text clipped - 24 lines] > > > > All suggestions are welcomed. >See also the code pages on the bottom SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > thanks for the reply. > Is there a way to this without using an add-in as i'm on a corporate network [quoted text clipped - 32 lines] >> > >> > All suggestions are welcomed. Hi Ron, Thanks for the links to the code aswell. Is there anyway to change the code to ignore blank entries? At the moment the code and also the add-in pull through all the fields within the range and many of these are blank. As such these need to be ignore. Can this be done? thanks, > >See also the code pages on the bottom > [quoted text clipped - 34 lines] > >> > > >> > All suggestions are welcomed. When the merge code is ready run a macro to delete the empty rows in the merge sheet See http://www.rondebruin.nl/delete.htm In the next version maybe I add a filter option SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > Hi Ron, > [quoted text clipped - 45 lines] >> >> > >> >> > All suggestions are welcomed. Thanks Ron :) > When the merge code is ready run a macro to delete the empty rows in the merge sheet > See [quoted text clipped - 51 lines] > >> >> > > >> >> > All suggestions are welcomed. |
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.