This is a pretty simple request, but i need a macro to Find Column M's Last Entry and to copy down the 3 following columns down to the value.
I need it to be dynamic in other words, The length of column M will vary depending on my file . If the macro knows Column M ends Here, then drags the boxes down starting from N3 to Q3 down to the last Entry in Column M.
I included a file here of before and after, this should help clear up any problems.
Thanks for any help
Last edited by donnydorko; 10-18-2009 at 01:19 AM.
Hello.
I take it that in the original file these cells are formulars.
If that is the case you can just insert the formular for the row into the used range based on Column M down.
eg
Hope that makes sence.
Please Login or Register to view this content.
i just want N3: to Q3: to be selected and dragged down till the last value in M.
I dont believe this will do that?
ok Try this.
it should do itPlease Login or Register to view this content.
works perfectly , appreciate the help. I know it is a simple request but it will help me out greatly.
THanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks