usa

Hi, Part of a software that the company uses exports dates in USA text format. How do I convert this to a UK text date. Ie 1st August 2017 is 42743 in USA but 42948 in the UK. I have hundreds of dates across multiple sheets (dates are always in G18:10000 and H18:10000) so I need some VBA...

Hi All, I have run into a wall on a data base I am trying to complete. I have a mass of data but I am primarily working with 3 columns that will finish up my workbook. For the purpose of this question I have scrubbed erroneous data. I have cell A with Name, cell B with Serial to Name and cell D...

Hi, I was wondering if anyone can helop me build a macro for a report i do every day. I have a master file that has multiple sheets. Every day i copy and paste some of these sheets into a new workbook. In my master file i am only concerned about 3 sheets, MasterF, Customer, Country. I copy and...

Hello All, I would like to count frequency of values in column A, so when I drag the formula down it should count the number of times the valued in column A appears up to the point where the formula is. This is how I want. <tbody> VALUES FREQUENCY H&M 1 H&M 2 H&M 3 DJ 1 DJ 2 H&M 4...

I want to restrict the options in a drop down list based on the data entered to another cell e.g. Country/city - is the user selcts USA as the country, they can only selct cities in the USA not UK, Germany etc although they will also be in the source data. Be greatful for any help