ham

I have a spreadsheet I am look for a macros to some thing in this. I am very new to macros and this was originally written by some one else. The macro is below The Macros is to sort the dispatch worksheet by date Newest to Oldest range A13:L38 after being updated ' it is then to put in a...

Desire: I am trying to create two macro buttons side by side at the beginning of each of my "active" rows, that will cut the row and either insert it above or insert it below the rows current location depending on which button is pressed (The first button would say Up or have an Up arrow, the...

How do I get to check two cells if they match and then return a value? I'm using an Id Statement but it's working for 2 out of 3 scenarios. =IF(A1=B1,1,0) A1 B1 C1 HAM HAM 0 BEEF BEEF 1 TURKEY TURKEY 1 The If Statement works on BEEF=BEEF and...

I have a software that exports its reports in tab delimited format, i have 26 of those to open in excel and i'm opening it individually, doing up the individual tab delimiting msgs, then moving each sheet to one workbook to combine them. - surely there must be an easier way to do all that! any...

Hi All I am hoping you can help me. I have to produce a holiday calender/sick calender for staff of 28. They can book half day am, halfday pm, full day, and there is sick am, sick pm, sick full day. so against each date i will enter HAM or HPM or HFD, same with the sick row SAM, SPM, SFD. I...