Re: Need help from an Excel guru

Subject: Re: Need help from an Excel guru
From: Chris Despopoulos <despopoulos_chriss -at- yahoo -dot- com>
To: techwr-l -at- lists -dot- techwr-l -dot- com
Date: Thu, 16 Dec 2010 00:21:03 -0800 (PST)

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


Previous by Author: Re: New rules for business correspondence
Next by Author: New rules for business correspondence
Previous by Thread: Re: Need help from an Excel guru
Next by Thread: I am suddenly having an odd problem with Word.


What this post helpful? Share it with friends and colleagues:


Sponsored Ads