PDA

View Full Version : NEED SOMEONE W/ EXCEL SKILLS WANTING TO MAKE SOME MONEY...



Paul
08-03-2009, 11:23 AM
I NEED SOMEONE TO EITHER CREATE A QUICK MACRO OR JUST FIGURE OUT A WAY TO DO THIS W/O MY INTERVENTION. I NEED THIS DONE ASAP AND I WILL PAYPAL YOU MONEY UPON COMPLETION.

BASICALLY...

I HAVE A EXCEL FILE W/ 3 COLUMNS:

PART#(COLUMN1,(20CHAR)), ID#(COLUMN2,(20CHAR)), DESC(COLUMN3)...

Currently column3 has random amount of characters depending on description, i need this column broken down into 45 char max with the remaining characters made into a separate record using the same column1/column2... it would probably be helpful to create a unique id for every record or number the records.

example:

12345, 67890, blah blah blah blah blah blah blah blah

i need it to be:

12345, 67890, blah blah blah blah,12345-001
12345, 67890, blah blah blah blah,12345-002

if you can do this PM me ASAP

ShooterMcGavin
08-03-2009, 11:58 AM
um i understand the 1st part of your request just fine...up until:

"with the remaining characters made into a separate record using the same column1/column2"

Paul
08-03-2009, 12:04 PM
um i understand the 1st part of your request just fine...up until:

"with the remaining characters made into a separate record using the same column1/column2"

i need the data broken into separate records b/c the DB system this is going into has a 50 char limit - meaning if the 3rd column has 100 characters it would need to be put into a separate record and that record still needs the appropriate column1/2

AirMax95
08-03-2009, 12:10 PM
Can you PM sample data?

ShooterMcGavin
08-03-2009, 12:19 PM
Can you PM sample data?
:stupid:

joecoolfreak
08-03-2009, 12:58 PM
Solution sent

§treet_§peed
08-03-2009, 01:11 PM
bastard i was about to make it :(

Paul
08-03-2009, 01:44 PM
i sent the file to couple people first to do it gets $$$

ShooterMcGavin
08-03-2009, 03:25 PM
i didn't get it

Paul
08-03-2009, 03:42 PM
obviously you didn't read directions PM me... i have someone working on it now anyway

ShooterMcGavin
08-03-2009, 04:18 PM
hater :2up: hope they send you back an excel file w/a virus :lmfao:

§treet_§peed
08-04-2009, 12:59 AM
lol