B
Barry Freeman
Hope you can help. I have a number of spreadsheets containing customer details and addresses. The details for each customer are contained in a single row, but the addresses read in a single column,eg.
Name | ID | Address | Org. | Currency |
___________________________________________________
J.Doe | 23 |101 Easy Street | 5221 | Euro |
|Nowhere Lane |
|Deadville |
Some addresses are longer than others. I can move the Address column to the end of the spreadsheet to prevent misplacing the Org. and Currency.
The spacing between each customer varies, between 1 and 10 blank rows. Some code i have tried requires fixed spacing.
Can you suggest some code that will allow me to move the rest of the address into the same row? I have to do this for nearly 18,000 customers!!
Submitted via EggHeadCafe - Software Developer Portal of Choice
Job Interview And Resume Tips for Developers
http://www.eggheadcafe.com/tutorial...83-8feb077fb0be/job-interview-and-resume.aspx
Name | ID | Address | Org. | Currency |
___________________________________________________
J.Doe | 23 |101 Easy Street | 5221 | Euro |
|Nowhere Lane |
|Deadville |
Some addresses are longer than others. I can move the Address column to the end of the spreadsheet to prevent misplacing the Org. and Currency.
The spacing between each customer varies, between 1 and 10 blank rows. Some code i have tried requires fixed spacing.
Can you suggest some code that will allow me to move the rest of the address into the same row? I have to do this for nearly 18,000 customers!!
Submitted via EggHeadCafe - Software Developer Portal of Choice
Job Interview And Resume Tips for Developers
http://www.eggheadcafe.com/tutorial...83-8feb077fb0be/job-interview-and-resume.aspx