static Variable Noobie help.

[dohara]

Ok, below is the code I have thus far. As of right now when the message box pops up it says 1 in the area I type. If I click ok, the next time it pops up I need it to go up 1. For example. If I type in 23, the next time the box comes up I need it to be 24. Any help would be great

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[jolivanes]

To my understanding, you filter on numbers in column F (6) in Sheet9.
The filtered data is then copied into Sheet10.
So you can retrieve the last filtered value and add 1 to it.
Is this thinking right?
If so, try this on a copy of your workbook.
BTW, minimize or get rid of the Activating and Selecting. It slows your code down
Use With...End With instead.

Please Login or Register  to view this content.

[dohara]

Jolivanes: It errors below. yes using column F in sheet 9 to decide which rows to copy to sheet 10.

Please Login or Register  to view this content.

[dohara]

Alpha frog: Works perfectly!!!!!!!!!! Ty.

[dohara]

Alpha frog: The data it is pulling from sheet 9 Collums C and D is being put into Sheet 10 as Text. How can I change that.

I have a

Please Login or Register  to view this content.

on sheet2 pulling this info from sheet 10.

[AlphaFrog]

Alpha frog: The data it is pulling from sheet 9 Collums C and D is being put into Sheet 10 as Text. How can I change that.

I have a

Please Login or Register  to view this content.

on sheet2 pulling this info from sheet 10.

If the values on sheet 9 are are numeric-text, then text is what gets pasted. If they are numbers, then numbers are pasted.

So if the columns C:D on sheet 9 have cell formatting as text, or if they have formulas that return text-numbers (quotes around the number in the formula), then that's is the cause of the problem.

If you imported the values on sheet 9 from a csv or text file, you may have to convert the numeric-text to numbers. Put a 1 in an empty cell. Copy it. Then Pastespecial-Multiply over columns C:D

[dohara]

The formula is the one you pasted above. I am not seeing any issues looking at it. They are numbers in sheet 9.

[AlphaFrog]

The formula is the one you pasted above. I am not seeing any issues looking at it.

I didn't give you a formula. I don't know what that means.

They are numbers in sheet 9.

Numeric-text "looks" like numbers. How do you know? I'm not trying to be difficult, but I cannot see your sheet and I don't know you skill level.

Can you post an example workbook that illustrates the problem?

[dohara]

This is what pulls from 9 to 10 (What you pasted earlier)

Please Login or Register  to view this content.

My skill level is low.

[dohara]

Ok I think I figured it out. Sheet8 pushes to 9 using

Please Login or Register  to view this content.

I am assuming this is my issue. I use the ""so it does not return a zero. Is there a way to make this numeric not text, without having a zero?

It is a massive workbook, to large to upload. If this is not my issue, I will create a sample.

[AlphaFrog]

Ok I think I figured it out. Sheet8 pushes to 9 using

Please Login or Register  to view this content.

I am assuming this is my issue. I use the ""so it does not return a zero. Is there a way to make this numeric not text, without having a zero?

It is a massive workbook, to large to upload. If this is not my issue, I will create a sample.

That's probably it. That formula returns numeric-text.

Try this...
=IF(Sheet8!C2="","",Sheet8!C2)

[dohara]

That worked! You Rock!