Move Rows to different Sheets based on Cell value(s) with Multiple Buttons

[SeventySix]

This is driving me crazy. I can't seem to figure it out and get it working properly. PLEASE HELP! lol

Please see the attached file. I need to send different rows in the table to different sheets in the file based on a cell value of TRUE or FALSE in helper cells. I am also using multiple vlookup values and I really need the rows moved over as a value instead of the formula.

"Goalpost" is the main sheet. Everything is entered there. The formulas there say whether or not the material is in overflow, needs to be sent to purchasing or is marked as an expedite.

Resupply is "TRUE" in column = U
Purchasing = T
Expedite = G

Shapes on the top of the workbook will be marco buttons for each process.

Any help?

[SeventySix]

I have 1 button working with a macro to copy based on 1 criteria in the file above, but whenever I copy, update the code and assign it to the different buttons nothing happens. No errors. What am I doing wrong?

Not looking for someone to do it for me, I just need someone to point me in the right direction please.

[AliGW]

Welcome to the forum.

Please be patient - we don't expect threads to be bumped unless 24 hours have passed. I am sure that you realise that the volunteers here are all over the globe - I'm in the UK, so was fast asleep when you posted in the early hours of my morning.

[WideBoyDixon]

I created three macros for the buttons and one generic macro. I also changed the formula for column G to not use the literal "TRUE" but rather the boolean value. I also copied the headers from the Goalpost sheet to the other sheets. Here's the macros I created:

Please Login or Register  to view this content.

And I've attached the adapted workbook; hopefully that points you in the right direction. Your original upload had external links so you may need to restore them.

WBD

[SeventySix]

Thank you so much.

What would be the best way to have an option button in the material userform to override a formula in column G and set that column in the row to TRUE? I would like the user to be able to click it and have that card set to expedite.


Private Sub OptionButton1_Click()


End Sub

[WideBoyDixon]

Using an option button would be tricky as you'd have to create a new one every time you added a row. If you want the user to be able to set this then you could toggle the value using the double click event in the column perhaps. See attached.

WBD

[SeventySix]

That'll work. Thank you so much.

[SeventySix]

The solution doesn't seem to be working for new entries. If I add lines the double click option is not available?

[SeventySix]

Figured it out