select range to copy, find values and copy

Hi guys im still plugging away...

Ive added some code for the user to select the range that needs to be coppied though not sure who to then use that range and to do the search part. File attached.

Any help would be so greatly appreciated...

thanks,

okay,

Mod to the code... have added global select buttons(see 'Intergral Dump' WS) to the top fo the month columns so the range of the column can be used to get the value.

Can I please have some assistance with the searching and copying the coresponding $ value etc,

thanks, ive exhausted my knowledge i think

new doc attached.


sp

Hi

Try this. It all hangs from the one button that selects the month.

rylo

Hi rylo,

wow, that is impressive. worked as expected.

Is there a way to ask the user for the location to copy the results to? Ie. user can click on another worksheet and click the first cell they want the findings to start from.

Ie: if the user navigates and selects: worksheet "master" , Column M, row 4 for the results to be copied from M4 down instead of the static offset atm?

Because on another worksheet (lets say 'Master') there is the WBS number and about 20 rows to the right (sometimes 15 rows, sometimes 3, sometimes 25) is where ideally the results can be coppied too.

Thanks, i hope this isnt too much of a pain.

oh, I did come up with my own solution, end to end though as soon as I saw the userform my eyes lit up, hence the extra ask! thanks again

Other than the above, its great, really is.

Hi

How about this one.

rylo

Hi rylo,

apologies for the confusion I was actualy trying to say that i wanted the user to be able to select where\he copies the results to.

with that said, what you actualy did is something i didnt think of though it will allow for the document to be much more dynamic, which is great.

as always i try to do the code myself though sometimes hit a snag, in this cause i did again...
I tried to add to your code (which i have attached), by adding another input box and setting the selection as 'frng', though when i tried to get it to work it is only copying 1 random result, rather than copying the result how you got them to output except not offsetting, rather using the first cell selected by the user to be the first cell to populate etc.

I think i have my code wrong cause thinking it through if the user selects the first cell it is using that as the 'frang' and thus will only ever fill that cell. ... I tried to various things though couldnt work it out..

hope i made better sense this time, thanks again

Also tried this but cant get it to go,.. tried all of this too but to no avail

Please Login or Register  to view this content.

Hi

OK, here's another one.

It will ask for the first cell of the data range, and the first cell of the output range.

rylo

wow! you did it,

im going to study the code so i can work it out, but this is just great.

your so good at this and always very helpful and understanding.