guru

Hi all Seek help. My excel level is just average with only little knowledge in VBA. I am looking for a simple VBA to self generate numbers with a given number with no duplicate. Example: In A1, I have 1234. A simple VBA which can generate number in a column B1, a series of numbers based on A1...

Hello all, I am working on a piece of code that currently works fine if you trigger the code sheet by sheet manually, but when I add a loop code it keeps entering the subtotals in the same sheet over and over again? Any help is appreciated! Sub forEachWs2() Dim ws As Worksheet...

So, I have a code that I have been working on now for 2 days and have hit a roadblock and not sure how to fix it. I am hoping one of you Guru's will simply look at it and see a line of code that is entered incorrectly or something. So here it is Sub Subtotals() Dim sht As Worksheet Dim subs...

Hello. I did a search and really couldn't find anything that returned row header information for this kind of problem. Hopefully someone here can lend me a hand. So here is what I am trying to do Name English German French John Yes Yes Yes Kim Yes Yes George Yes Yes...

I have a number A A:846 I have a number like B: 14000.56 C: 2.51 D: 524.5 E: 25.25 As number A is 3 digits and a integer I would like to work out factor 'X'. X is the factor to convert B,C,D,E to three digits integer. Like B: 140 , X = 0.001 C: 251, X = 100 D: 526, X = 1 E: 252, X = 10...

Hi, I need the help of a guru because I'm hitting my head over here and nothing I've searched answers this question, I have a bunch of tables in excel that are populated from a stored proc on MS server. I want to delete the table and create a new one each time since as I make changes to the...