Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering info into different worksheets
Hi I want to strip out a list of information in this case a phrase, all from the same worksheet and place them in a different worksheet by category. For example if the list is like this: current inflation rate current UK inflation rate sipps uk inflation rate uk interest rate predictions alternative energy gold prices newspaper articles price of silver share prices today uk interest rate forecast gold price buy gold uk stock market currency forecasts HOUSE PRICE PREDICTIONS HOUSE PRICE PREDICTION I would want to put all the terms that include gold into one worksheet and those with interest rate into another and so on. I would already have the required worksheets created and named for example gold and interest rate How would I do this. With a formula or a macro. Also I would want to strip out/delete the phrase from the original list so I know what to do with the left overs. If someone knows a formula or macro that would do this I would be most grateful. :) -- exiled ------------------------------------------------------------------------ exiled's Profile: http://www.excelforum.com/member.php...o&userid=35619 View this thread: http://www.excelforum.com/showthread...hreadid=553972 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a workbook that the worksheets update info | Excel Worksheet Functions | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Transfer Info From Worksheets | Excel Discussion (Misc queries) | |||
Can a formula operate between worksheets, ie collating info from . | Excel Worksheet Functions | |||
Adding rows of different info from separate worksheets into summar | New Users to Excel |