billy

Good day all, I'm trying to pull the weekly attendance of personnel, at the moment i do this manually (not clever enough to do the other bit:confused:), please see my screenshot of an example, I have on another sheet all the week numbers and dates they start/finish on. So I get the information...

Hi, I'm new to VBA and wanted some help drafting out a code that would help me automate the following process: 1. Create different sheets based off of names on a master sheet (eg: below) 2. List corresponding product names to a particular name in the respective sheets (for instance: Adam would...

Hi All, I'm looking for a formula that will return a desired output based on the formatting of a cell, specifically the cell colour. For instance if the cell is green, then return the value of the cell. As far as I'm aware it seems that this can only be done using VBA programming, if so...

Hi Master Need your help please. First sorry for my bad english. I have two colomn contain string character, example like this: Colomn A1: Billy Colomn B1: Adam Which is wrong alphabetical order, so in Colomn C1: equal to 0 It should be: A1: Adam B1: Billy Colomn C1: equal to 1 This in...