PDA

View Full Version : VBasic in Excel


Win2Kuser
03-13-2004, 6:31 AM
Hi y'all,

I am looking for a way to create a report from Excel.

A have a table with a condition flag, I would like to be able to log this flag along with other information into a report that can be easily bought into notepad i.e. space denominated values.

hmm, that didn't explain it very well, try this.

I am comparing two values, today and yesterday, if today has gained a certain amount, I have used VBasic script to test the values and respond by placing 'yes' into a cell. I would like to be able to check the columns for the 'yes's and add the info from several other rows into a file that expands as it finds more.

I am reasonably able to fugure it out once I have somewhere to start.

Any ideas?...

TIA