Row color change if specific cells have any value

it worked!!!!!!!!!! thank you thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

i have 2 more tweaks and everything will be completed and help with saving time

this it it, this is the final version.......the end of the race.....at the end of the road TWEAK!!!!!!!!

1. the drop down menus i have, is it possible to have a search function instead of scrolling up and down? lets say im looking for bobby. when i type "bo", it will show the names related to those words "bob" or Bobby" and i can simply select it.

*So i basically rearranged the sheet and added some new headings and things are a are a bit off. wanted to make sure i set the stage so you can visually see it

for my second streamline idea, i will try and explain this the best i can

2. i will like to copy specific cell vales (not colors) from "main sheet" or "Outstanding Sheet" to my invoice sheet if there is an invoice number in column J and Date Collected (Column O) is selected afterwards

*Bin Size (Column A) from row 3 , copies to the next available cell starting in row 23 to Invoice sheet (Column BC merged)

*Bin Price (Column C)from row 3 , copies to the next available cell starting in row 23 to Invoice sheet (Column E)

*Extra Days (Column E) The Heading In "row 2" copies to the next available cell starting in row 23 on Invoice sheet (Column BC merged)

*Extra Days (Column E) from row 3, copies to the next available cell starting in row 23 on Invoice sheet (Column D)

*Extra Days Price (Column F) from row 3, copies to the next available cell starting in row 23 on Invoice sheet (Column E)

*Equipment/Material (Column G) from row 3 , copies to the next available cell starting in row 23 on Invoice sheet (Column BC merged)

*Material Prices (Column H) from row 3, copies to the next available cell starting in row 23 on Invoice sheet (Column E)

*Delivery Prices (Column I) from row 3, copies to the next available cell starting in row 23 on Invoice sheet (Column E)

Regarding your two NEW questions ... it is better to go step by step ...

i agree

If you want to work with the AutoComplete feature in your dropdowns, you will need to insert an ActiveX ComboBox

no idea what that is lol

Quote

You have attached a new file in Message #21 ... and it creates PLENTY of New Confusion !!!

The Main sheet shows a different structure ... and many new Columns have been inserted ... which will prevent all the macros from working properly ... !!!

yes i know, if its to much i can continue with the final sheet you completed for me. i saw that everything was completed upside down when i added knew columns

is that ok with you though?

i know macros is a pain the the butt, and to re due them is a a pain in that butt

so i might as well just keep the original format, and work with my invoice?

ok well this work without redoing all the macros??

*Bin Size (Column A) from row 3 , copies to the next available cell starting at cell 23 downwards to Invoice sheet (Column BC merged)

*Bin Price (Column C)from row 3 , copies to the next available cell starting at cell 23 downwards to Invoice sheet (Column E)

*Invoices (Column E) from row 3, copies Invoice sheet (Column F5)

*Extra Days (Column F) The Heading In "row 2" copies to the next available cell starting at cell 23downwards on Invoice sheet (Column BC merged)

*Extra Days (Column F) from row 3, copies to the next available cell starting at cell 23 downwards on Invoice sheet (Column D)

*Locations (Column G) from row 3, copies Invoice sheet (Column BC23 Merged)

*Customers (Column H) from row 3, copies Invoice sheet (Column BC13 Merged)

*Date Delivered (Column H) from row 3, copies Invoice sheet (Column B20)

*Date Delivered (Column H) from row 3, copies Invoice sheet (Column C20)

*Date Delivered (Column H) from row 3, copies Invoice sheet (Column F4)

sorry didnt see this, yes im sure, i dont want you redoing everything