Recent content by jbaich

Hi Stevie, another member who had been helping me previously has graciously offered to take a look as well, so in order not to duplicate effort and possibly waste anyone's time, I'll see if we can find a solution, but in the event that we can't, I will try to post a file or visual example as...

Hi everybody, I have 2 macros that both work perfectly on their own. Each macro is a loop that runs off a different worksheet, so for example Macro 1 (loop 1) runs on sheet 1 and macro 2 (loop 2) runs on sheet 2. I would like to combine these so that rather than loop 2 just looping through all...

Hi p45cal, thanks again for such a quick reply! You have been able accomplish exactly what I was hoping to achieve, except I will need to ether create or input the sheet1 that your macro creates in the active workbook... It used to be that we started out with a blank template and manually...

Holy Cow!!! That's incredible! I've never even heard of some of the code you used... :) So, I didn't include the entire workbook and all the macros in it because I've been told previously that doing that when you have a question is bad form, but it might have been a little helpful here in...

Hi p45Cal, thanks for the response! I was starting to think I'd either asked the question poorly or it was just impossible! I realize now that I should have been more clear earlier that the Desired Outcome sheet is a total dummy sheet, the sole purpose is to provide an example of the...

I just noticed that I had some small formatting mistakes on the "Desired Outcome" worksheet... but I don't see how to replace the file and it seems maybe a little unnecessary to upload another copy just for that... Please let me know if I should upload a new copy. Thanks, Joe

are you wanting to basically consolidate all the sheet 1s together, all the sheet 2's together etc? so that you start with 3 sheets and end up with 3 sheets? or are you wanting to end up with 1 sheet?

Hello again Chandoo Forum! :) I think I'm trying to do something very similar to the author of this post... http://chandoo.org/forum/threads/how-can-i-make-a-more-dynamic-self-filling-table.27263/ ... But I don't really understand how the solution provided by Vletm works. I have uploaded a...

Hi Narayan, every it tries to run the Debug line in either sub it gives me a Run-time error '1004: Method of 'VBE' of object'_Application' Failed. So I tried inserting the 'With Application.FileDialog(msoFileDialogFolderPicker)' code that I'm using to define the Rootfldr variable, but that...

Hi Narayan, i'm sorry for the confusion... i think this should be really, really simple, i don't know why i've been having trouble with it... I will try to explain as clearly as i possibly can... The module i'm working on contains 3 sub routines; Sub 1(), Sub 2() and Sub 3(). In the first Sub...

Thanks jindon, I will try that out tomorrow!

i see from that link what you mean about "let" being optional, so i can't explain why it only worked after i used it... I've been trying to figure this out for almost a week and this is the first time it ever "worked"...

before i used it, the values were "erased" after the first sub ended... after i used it, they were not... that was the only thing i changed in my trials and errors...?

i should maybe also mention that the user chooses the file path using folder picker in the first Sub, so the path can't be defined until the user has chosen... if that means anything... this is why i didn't think i could make a constant because i thought i'd have to have the file path...

Hi Narayan, jindon and Marc... sorry about the choppy feeling response, I'd written it before i'd seen your responses, but it seems to have been delayed being posted so it came in after. I think what i'm after is just a variable that behaves like a constant... in the first sub, the user defines...