# Posts by miamiheat

• ## Macro that moves checked selections to new sheet

haha yes i am a huge miami heat fan

appreciate it. I am reviewing it and breaking it down though. but i am learning a lot from you

• ## Macro that moves checked selections to new sheet

Carim if you have time could you explain your array formula and how it works. Obviously do this in your spare time, I dont know how complicated it is to explain.

thanks!

• ## Macro that moves checked selections to new sheet

wow!

an array formula is exactly what I've been trying to do.

time to learn how to do one!!

thanks Carim!

Here it is

Awesome!

• ## Macro that moves checked selections to new sheet

Can someone make a macro that moves check boxes to one sheet and unchecked boxes to another sheet?

• ## Graph for x-axis=date vs y-axis=number of cells

figured it out thanks!

• ## Graph for x-axis=date vs y-axis=number of cells

I'm not having luck... I'm new to pivot tables haha. trying to learn by watching videos.

• ## Graph for x-axis=date vs y-axis=number of cells

Thanks Carim!

Can a pivot table be continuously updated?

I want the graph to always be updating with new logs

• ## Graph for x-axis=date vs y-axis=number of cells

I am now using a countif within an if statement (except for the first date)

Code
``=if(B3<>B2,COUNTIF(B:B,B3),``

trying to figure out how to say if the one before it does not equal the current one count number of cells with that date.... if it does equal, skip

• ## Graph for x-axis=date vs y-axis=number of cells

trying to use countif formula but since this is a running log I am trying to figure out how to continuously keep adding dates

• ## Graph for x-axis=date vs y-axis=number of cells

I would like to do a graph that does what the subject says...

so basically on the axis you have each day... then y axis the number of cells each date has

• ## Submittal form/ clears contents of row after macro runs

BOOM

thanks again haha

• ## Submittal form/ clears contents of row after macro runs

All good i figured it out

Thank you!

How do I clear row but not the formula?

Or clear a row but exclude one of the columns?

I want to clear everything except column A and the headers

• ## Submittal form/ clears contents of row after macro runs

Figured it out by assigning the radio button to cell A3

then in cell A2 I put

Code
``=if(A3=1,"Bin Washer",if(A3=2,"Poweder....``

But it only works for Bin Washer but not the others... any ideas?

• ## Submittal form/ clears contents of row after macro runs

Instead of posting a new post I am just going to keep this one going since it's part of the same project...

I would like that instead of "5" being placed in there that the actual text be put into the cell.

Thanks!

• ## Submittal form/ clears contents of row after macro runs

WORKS THANK YOU!!!!!

• ## Submittal form/ clears contents of row after macro runs

Yes! I am trying to get in touch with him on more things! I need to donate to him to keep him going haha

Can I just add this at the end? I am super new to VBA and trying to teach myself.

thanks a million man! glad i found this site

Also, do you recommend any courses or books to learn VBA?

• ## Submittal form/ clears contents of row after macro runs

Copy_To_Wroksheets_2

and row 2... but not delete the row, just the contents, like reset it since im basically making a submittal form

thanks!

and thats for welcoming me