Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Rearrange same row
Okay this is for the bright ones out there, or is it easy?.
I have a lot of text in cells all scattered along the same Row but it's not aligned into the same Column. The macro can know easily what column it goes into (again without changing the row which all stays together) because the first part of the text is named like the Column. For example if the text says "Name John" then it needs to be placed in the Column that says "Name." So in other words the Macro would take all the contents of this cell just because it starts with "Name" and place the whole thing "Name John" into the Column that says "Name" without moving it outside the original row. There are about 30 different Columns and they change for each project/worksheet so I need a Macro where I can choose the new Column names and the text is scanned and placed into the respective named columns. Is this too tough a job for this site? Example: Text before Sorting Name Car House Name John Car Chevy House Ranch Car Ford Name Mary a blank cell House Blue Car Chrysler Name Bob After Macro Sort Column Rearrange Name Car House Name John Car Chevy House Ranch Name Mary Car Ford an actual blank cell (nothing here at all) Name Bob Car Chrysler House Blue As you can see sometimes there is no value for a column or row and that's okay and should stay blank since it has no name that matches the Column Name So I should be able to make a list 1. A 2. B 3. C 4. etc. and the Macro/code would know that the terms in the list are the new Columns which means, too, it is also the beginning words of the text in the cells to be rearranged. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Rearrange same row
Usually these type problems should be fixed before the data is placed into an
excel spreadsheet. I need a sample of the source data to be able to fix the problem. Problems like this occur because the TEXT-TO-COLUNS function in excel didn't correctly determine where each to the columns started and ended. yo may of had TAB delimited data and excel though it was fixed width data and put the information in the wrong spot. The problem is probably due to some information misssing in each row. The TEXT-TO_COLUMN (DATA menu) function is also part of the reading text data (File - Open) and is also used in the Data - Import External Data menu options. "mypetduke" wrote: Okay this is for the bright ones out there, or is it easy?. I have a lot of text in cells all scattered along the same Row but it's not aligned into the same Column. The macro can know easily what column it goes into (again without changing the row which all stays together) because the first part of the text is named like the Column. For example if the text says "Name John" then it needs to be placed in the Column that says "Name." So in other words the Macro would take all the contents of this cell just because it starts with "Name" and place the whole thing "Name John" into the Column that says "Name" without moving it outside the original row. There are about 30 different Columns and they change for each project/worksheet so I need a Macro where I can choose the new Column names and the text is scanned and placed into the respective named columns. Is this too tough a job for this site? Example: Text before Sorting Name Car House Name John Car Chevy House Ranch Car Ford Name Mary a blank cell House Blue Car Chrysler Name Bob After Macro Sort Column Rearrange Name Car House Name John Car Chevy House Ranch Name Mary Car Ford an actual blank cell (nothing here at all) Name Bob Car Chrysler House Blue As you can see sometimes there is no value for a column or row and that's okay and should stay blank since it has no name that matches the Column Name So I should be able to make a list 1. A 2. B 3. C 4. etc. and the Macro/code would know that the terms in the list are the new Columns which means, too, it is also the beginning words of the text in the cells to be rearranged. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Rearrange same row
Yes the data comes from PDF and isn't always exactly in the same order
because the information varies and so the next cell will not follow sequentially. Are you saying there's a way to download it in correct cells even given this fact? "joel" wrote: Usually these type problems should be fixed before the data is placed into an excel spreadsheet. I need a sample of the source data to be able to fix the problem. Problems like this occur because the TEXT-TO-COLUNS function in excel didn't correctly determine where each to the columns started and ended. yo may of had TAB delimited data and excel though it was fixed width data and put the information in the wrong spot. The problem is probably due to some information misssing in each row. The TEXT-TO_COLUMN (DATA menu) function is also part of the reading text data (File - Open) and is also used in the Data - Import External Data menu options. "mypetduke" wrote: Okay this is for the bright ones out there, or is it easy?. I have a lot of text in cells all scattered along the same Row but it's not aligned into the same Column. The macro can know easily what column it goes into (again without changing the row which all stays together) because the first part of the text is named like the Column. For example if the text says "Name John" then it needs to be placed in the Column that says "Name." So in other words the Macro would take all the contents of this cell just because it starts with "Name" and place the whole thing "Name John" into the Column that says "Name" without moving it outside the original row. There are about 30 different Columns and they change for each project/worksheet so I need a Macro where I can choose the new Column names and the text is scanned and placed into the respective named columns. Is this too tough a job for this site? Example: Text before Sorting Name Car House Name John Car Chevy House Ranch Car Ford Name Mary a blank cell House Blue Car Chrysler Name Bob After Macro Sort Column Rearrange Name Car House Name John Car Chevy House Ranch Name Mary Car Ford an actual blank cell (nothing here at all) Name Bob Car Chrysler House Blue As you can see sometimes there is no value for a column or row and that's okay and should stay blank since it has no name that matches the Column Name So I should be able to make a list 1. A 2. B 3. C 4. etc. and the Macro/code would know that the terms in the list are the new Columns which means, too, it is also the beginning words of the text in the cells to be rearranged. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Rearrange same row
I usually can convert almost anything EXCEPT PFD. I tried a few times in the
past and have not been very successful. Adobe puposely makes it difficult to convert so you have to buy there converter (Adobe profesional writer which has a PDF to word converter). From word you can easily go to excel. There are a few other converters on the market.converters. I've been successful in converting parts of a pdf document but never the whole thing. Adobe has several differnt format for a PDF file and some converter better than others. "mypetduke" wrote: Yes the data comes from PDF and isn't always exactly in the same order because the information varies and so the next cell will not follow sequentially. Are you saying there's a way to download it in correct cells even given this fact? "joel" wrote: Usually these type problems should be fixed before the data is placed into an excel spreadsheet. I need a sample of the source data to be able to fix the problem. Problems like this occur because the TEXT-TO-COLUNS function in excel didn't correctly determine where each to the columns started and ended. yo may of had TAB delimited data and excel though it was fixed width data and put the information in the wrong spot. The problem is probably due to some information misssing in each row. The TEXT-TO_COLUMN (DATA menu) function is also part of the reading text data (File - Open) and is also used in the Data - Import External Data menu options. "mypetduke" wrote: Okay this is for the bright ones out there, or is it easy?. I have a lot of text in cells all scattered along the same Row but it's not aligned into the same Column. The macro can know easily what column it goes into (again without changing the row which all stays together) because the first part of the text is named like the Column. For example if the text says "Name John" then it needs to be placed in the Column that says "Name." So in other words the Macro would take all the contents of this cell just because it starts with "Name" and place the whole thing "Name John" into the Column that says "Name" without moving it outside the original row. There are about 30 different Columns and they change for each project/worksheet so I need a Macro where I can choose the new Column names and the text is scanned and placed into the respective named columns. Is this too tough a job for this site? Example: Text before Sorting Name Car House Name John Car Chevy House Ranch Car Ford Name Mary a blank cell House Blue Car Chrysler Name Bob After Macro Sort Column Rearrange Name Car House Name John Car Chevy House Ranch Name Mary Car Ford an actual blank cell (nothing here at all) Name Bob Car Chrysler House Blue As you can see sometimes there is no value for a column or row and that's okay and should stay blank since it has no name that matches the Column Name So I should be able to make a list 1. A 2. B 3. C 4. etc. and the Macro/code would know that the terms in the list are the new Columns which means, too, it is also the beginning words of the text in the cells to be rearranged. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Rearrange same row
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column and rearrange rows | New Users to Excel | |||
rearrange multiple columns under one column | Excel Discussion (Misc queries) | |||
I need to rearrange the information in a column. Help? | Excel Discussion (Misc queries) | |||
I need to rearrange the information in a column. Help? | Excel Discussion (Misc queries) | |||
Rearrange numbers from a column in a different order in a second c | Excel Discussion (Misc queries) |