tidy up

Hiya, Is there anyway I could tidy up/reduce this formula to still get the same outcome? I'm basically trying to sum up all the cells across multiple columns where the criteria matches the content of two seperate cells in another worksheet. Example: Based on the two sheets below - I wanted...

Hi I have the Following Code that repeats its self every 30 rows. is there a way for make the "IF" do this until the sheet no longer as filled in rows as the procedure is too large to run at the mo. I realise i can split it up into different subs, but i would like it to all run together...

Hi, i'm slowly getting there after copying loads of examples and working through modify and create my own code to make a userform front end for a database, i'm almost done but looking back through the code some of the parts i have done myself look a little 'messy' but as they are specific to my...

I need some code or formula to look at a cell to check the entered characters do not exceed last say 25 characters. If it does trim it down to the last full word then place the rest in the next cell along. So if Cell A1 had: (Unit 27a 150 Biglongmassive Street) it would change it to: Cell A1...

I have some code that works and does exactly what I need it to but it occurs to me that it could be a lot tidier and easier to edit and change as required. The code has come from various other codes and has been "cobbled together" a bit but as I say it does work. The code(sorry for the...