Code not working exactly, copy and paste issue

**jpthelpguy** · 01-21-2009, 09:53 PM

I am so close, but just can't seem to make this work. I am trying to get the formulas to work on Sheet 3, the rows formated to percentages correctly, but they are not reading the totals in row 2 to make the formula complete.
I also want this to run more than one number, I would prefer a range for example value >= 1.29 so that Sheet 3 shows all items less than 1.29.

Here is the code I am using"

Please Login or Register  to view this content.

I also think there is some code here that I do not need as I have been tweaking it, and it seems to run with or without some items.

thanks for the help, I attached a file for further reference.

**rylo** · 01-22-2009, 12:11 AM

Hi

See if this give you some ideas.

Please Login or Register  to view this content.

rylo

**jpthelpguy** · 01-22-2009, 12:19 AM

Rylo, that did exactly what I asked for, however now that I see it, how to keep the - numbers from showing up. I only need <= 1.29 to 0.00. Is there a but? code that I could plug into that?

**jpthelpguy** · 01-22-2009, 01:19 AM

Disregard and Thank you Rylo...

You got me on the way, I figured it out. I pasted the code below for anyone else who runs across that issue.

Please Login or Register  to view this content.

**jpthelpguy** · 01-22-2009, 01:42 PM

When I solved this, I was using my laptop, and it worked with the first Code. However, at the office, my spreadsheet added a line. I found that it was caused due to the hidden = true part of the code. Here is the same code altered slightly which seems to work in my version at the office now.

Please Login or Register  to view this content.

Note: The change is in the "IF NOT" line of code.

Code not working exactly, copy and paste issue

LinkBack

Thread Tools

Rate This Thread

Display

Code not working exactly, copy and paste issue

Got it Done!

Spreadsheet Adds a Row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions