Script to auto fill cells based on multiple criteria.

See my attached workbook. I need a code that can take the value in Resource Detail:Col A and copy it into each column, starting with the start date through and including the end date which is listed in Resource Detail:Col C and D. So for row 5, it would copy 1.50 to every column from 8/17 to 6/30 which can be found in Row 2. I would also like a way for it to skip columns that are either Sat or Sun (row 1).

i'm guessing there's a better way to do this. but this will do the job, I believe:

Please Login or Register  to view this content.

Since this is a function, how do I use this? Am I putting a formula somewhere on the sheet?

Originally Posted by narrowgate88

Since this is a function, how do I use this? Am I putting a formula somewhere on the sheet?

you know that there are 2 primary routine names in this language, right? functions and subs. I don't believe functions can be run directly from button click actions. you will have to change the title of the code routine to sub to get it called that way. functions can run from anywhere => directly from the VB editor by clicking the play button, or they can be called from other places in the code, behind any object. you simply have to make sure either block of code is in the first line of the routine:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

if there is no qualifying statement before the word function, it is visible as ""global"", or what is called ""public"" by the coding environment.

does that help?

Originally Posted by rorya

FWIW, yes they can.

I can't really see why this would be written as a function though, when it doesn't return anything.

thank you! I will remember that. the reason why it is written as a function is because I always post code in the form of a function. I do that so people are learning can always run the code directly in the VBA editor simply by pressing the PLAY button. my code posting has nothing to do with programming standard. but yes, you are correct, and I apologize, if I were being ""proper"", I would obviously only post functions when a returns are justified, and subs when they are not.

Originally Posted by rorya

You know you can do that with any routine (sub or function) that doesn't require arguments?

well I have never been able to write the following code and push the PLAY button inside the editor when the cursor is sitting in the middle of the routine's code. what do I have to do then?

Please Login or Register  to view this content.

Originally Posted by rorya

Just give the routine a name.

ummmm....yeah. so, why hasn't it worked for me!? hmmmm....I just ran a test and it works fine behind any object. hmmmm. thanks rorya

The code above is not working quite like I need. After converting it to a sub, it's not taking into account the start and end date when it does its for each segment. It's filling them all out through 6/29/21 and it's not ignoring the Sat/Sun columns.

It also skipped all the F and G columns which seems weird and possibly unrelated to the code.

I'm not really sure what you're talkin about or why that's happening for you because I remember distinctly running this on my end and it worked perfectly. can you post the resulting workbook after running the code that was posted?

I remember distinctly running this on my end and it worked perfectly

Really
Nowhere in the code is it looking at the dates & considering you've got MA as the last column, how is this meant to work

Please Login or Register  to view this content.

Originally Posted by Fluff13

Really
Nowhere in the code is it looking at the dates & considering you've got MA as the last column, how is this meant to work

Please Login or Register  to view this content.

there's always a possibility I'm wrong Fluff. hmmmmm....it doesn't look like those args are valid, does it? I guess that makes perfect sense. thanks for pointing it out. The OP has not gotten back to anyone in a while. Personally, I'm going to wait until he/she posts the code they ran. by the way, don't I know you from somewhere, Fluff? I believe from another board, but I can't remember which one. Care to jar my memory? I think I know, but....

don't I know you from somewhere, Fluff? I believe from another board, but I can't remember which one. Care to jar my memory? I think I know, but....

It was from MrExcel where you posted under the name of ajetrumpet & got banned.

oh yes, now I remember. one of those moderators has a disdain for me. Can't remember who that was, but I do have his picture. but anyway, thanks for the correction again.