LinkBack URL
About LinkBacks
Are your files Excel 2003 files or 2007? Also, the Master file shouldnt be in the same folder. If you do need to keep it in the same folder, then let me know and i will add a code line to ensure that the file is not included in the consolidation.
Are your files Excel 2003 files or 2007? Also, the Master file shouldnt be in the same folder. If you do need to keep it in the same folder, then let me know and i will add a code line to ensure that the file is not included in the consolidation.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
hello arlu
thx u for your prompt response, i really appreciate it.
i used the template i uploaded and pasted the macro onto that file and it appears to work great!
also, is it possible for the macro to only copy/paste values? i have drop down list so when i run the macro ...it is trying to overwrite the the drop down list names in the "defined name" section.
also, one final thing....in my source file...row 50 contains some data....so the macro does not work...is it possible to limit the macro to search only in the range C10:X47 (check the last row +/- within that range)?
thx u sir!
Last edited by jw01; 02-24-2012 at 12:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks