Re: Need help from an Excel guru

[Chris Despopoulos <despopoulos_chriss -at- yahoo -dot- com>]

All the concerns and issues notwithstanding, my inclination would be to hunt 
online for excel VBA scripts that do the following things:
* Loop through all the rows of a table
* Store the content of a specific cell in a variable
* Write a variable to a specific cell

All this is standard stuff -- with those simple actions you could do the job.  
The pseudo code for the script would be:

FOR each row in table:
* Set tmp to "" (empty string)
* Get cell A in tmp
* If tmp is not empty, copy tmp to cellAvar
* Get cell B in cellBvar
* Write cellAvar to cell C
* Write cellBvar to cell D

Then manually delete cols A and B.  Once you figure out how to make a VBA macro 
and run it in Excel, it should take you minutes to write this code.  If you know 
NOTHING about VBA, you should be able to accomplish this in a couple of hours, 
and you'll have VBA under your belt, to boot.  Of course, you have saved off a 
backup copy of the spreadsheet first, right?



      
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Create and publish documentation through multiple channels with Doc-To-Help. 
Choose your authoring formats and get any output you may need. Try 
Doc-To-Help, now with MS SharePoint integration, free for 30-days. 
http://www.doctohelp.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to 
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/ for more resources and info. 

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat