font-size

Hi, first post. I was wondering if I could get help on developing a macro that would add dollar amounts in a range. I’ve looked at formulas but that will not work in this case. In my research i found the following: Conditional Logic in VBA In the most of programming specific sections of...

Hi This is my first post. I’m trying to set up a macro that uses Solver and I have some code below. I was wondering if someone could take a look to see if I’m on the right track. This is what the macro should be doing: Numbers will always be present in one or all of the...

Hi I have the following VBA program that works but I would like to make two changes and just not having any luck. The first change is to have the existing "1-1" accept any number combination (say 1-99 or 99-1) right now it only accepts 1-1 as a positive result. My second request is to the have...

Using VBA (must be used because there is more to this coding) I need to find the location of a manually entered number, 1 to 10 are the only choices. The number gets entered in cell C17. As an example say I’m looking for number 7 (could be any number 1- 10). I have 5 columns where the above...

Hi I’m a newbie to Excel and have spent many hours with no luck on this one. Using actual cell locations here is the project: 1) In cell C17 I enter one number, can any number from 1 to 10. Lets say I choose the number 4 as an example. 2) I have 5 locations where number 4 could be...

Hi Everyone. Hope you're all well. I'm looking for something. Can you please suggest some trick, formula or a macro to achieve this: Source: 1. I have data (Job Details) in 'OperatorDetails' sheet, where Operators fill in the details on daily basis. For example: <colgroup><col...

Hi All I found the following formula which almost gives the results I require:- <style>table { }.font5 { color: black; font-size: 9pt; font-weight: 700; font-style: normal; text-decoration: none; font-family: Arial, serif; }.font6 { color: black; font-size: 9pt; font-weight: 400...

Given data prepared as in the attached spreadsheet Given a sheeet with Column A of values (say names) with corresponding columns B, C, D, etc. containing values relevant to row A, how would you created additional rows for the names in Column A, 1 each for each value in columns B, C, D, etc...