Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bring a code from a cell to a column
Dear all
I am working in Office 2003 edition. I have export from an ERP a sheet where ther are some codes with some prices and the information are split it to paragraphs. For example in cell D150 i have the code of a group of products and followed from line D156-D165 with subcodes of sub-parts of the specific code product. The case. I want to bring in cells A156-A165 the code of D150. This will help me to have in column A the main Code and in column B the sub codes. Imagine an excel sheet with 25.000 lines, so i am looking for an easy way of copying and paste fomrula. Also there is a possibility when a line is empty not to bring anything? Because as i said the information is spli it in paragraphs and i have quite a lot of empty lines. There is a smaple file in the following link: http://rapidshare.com/files/7903304/SAMPLE.xls.html Thanks in advance Manos |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bring a code from a cell to a column
Anyway you can put sample material in the columns? I'm looking at it but not
really understanding what type of data will be there. -- -John Please rate when your question is answered to help us and others know what is helpful. "Manos" wrote: Dear all I am working in Office 2003 edition. I have export from an ERP a sheet where ther are some codes with some prices and the information are split it to paragraphs. For example in cell D150 i have the code of a group of products and followed from line D156-D165 with subcodes of sub-parts of the specific code product. The case. I want to bring in cells A156-A165 the code of D150. This will help me to have in column A the main Code and in column B the sub codes. Imagine an excel sheet with 25.000 lines, so i am looking for an easy way of copying and paste fomrula. Also there is a possibility when a line is empty not to bring anything? Because as i said the information is spli it in paragraphs and i have quite a lot of empty lines. There is a smaple file in the following link: http://rapidshare.com/files/7903304/SAMPLE.xls.html Thanks in advance Manos |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bring a code from a cell to a column
An example
http://rapidshare.com/files/7918925/SAMPLE2.xls.html "John Bundy" wrote: Anyway you can put sample material in the columns? I'm looking at it but not really understanding what type of data will be there. -- -John Please rate when your question is answered to help us and others know what is helpful. "Manos" wrote: Dear all I am working in Office 2003 edition. I have export from an ERP a sheet where ther are some codes with some prices and the information are split it to paragraphs. For example in cell D150 i have the code of a group of products and followed from line D156-D165 with subcodes of sub-parts of the specific code product. The case. I want to bring in cells A156-A165 the code of D150. This will help me to have in column A the main Code and in column B the sub codes. Imagine an excel sheet with 25.000 lines, so i am looking for an easy way of copying and paste fomrula. Also there is a possibility when a line is empty not to bring anything? Because as i said the information is spli it in paragraphs and i have quite a lot of empty lines. There is a smaple file in the following link: http://rapidshare.com/files/7903304/SAMPLE.xls.html Thanks in advance Manos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |