hi
i have the following code:
the issue:
Please Login or Register to view this content.
i would like for the macro to paste the data start from cell C13:AJ
it works..but its pasting the data now in row 13 of column C....can someone pls help and advise?
Last edited by jw01; 04-03-2012 at 09:07 AM.
Where do you want the data to paste? this will paste starting at C1, you can modify the commented row as needed
Please Login or Register to view this content.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
hey thxs for your help
i have changed the cel to b13...but for some reason it's not consolidating the data from all the unhidden worksheets? can u pls help?
*see link*..im having some issue uploading :S
https://skydrive.live.com/redir.aspx...CBc3-EgrNCjfgk
thx u so much!Please Login or Register to view this content.
I cant view the file due to firewall, but try this
Please Login or Register to view this content.
hey im getting an error "object required" on this line
ur thoughts?Please Login or Register to view this content.
the newsh is the sheet object so it does not require the .name paramater
try this
Please Login or Register to view this content.
actually its notwrking at all now....when i paste the new code :S
Last edited by jw01; 03-30-2012 at 10:05 AM.
could you include a sheet with sample data? i cannot access skydrive.
it's not uploading the file on this thread for some wierd reason :S
i uploadd it onto google docs...u dont need to sign in...let me know if this works.
https://docs.google.com/open?id=0B1Q...Rm5BRGVadUtadw
thxs!
Last edited by jw01; 03-30-2012 at 11:29 AM.
took a look and made a couple change, give this a run
Please Login or Register to view this content.
omg thxu so much for your great help....i was confused...it appears this was the missing link "And Sh.Name <> Sheet20.Name"
also...real quick...i have a formula in column B on the consolidation sheet
if(C1="",0,1)
where if 1...then i have a conditional format for the row to have a border ...else if 0 then no border....
that part is not coming through...any idea why? thx u sir
this should take care of that
Please Login or Register to view this content.
hello that works like a charm....thx u so much..it is much appreciated.
once final request..or rather an issue that is showing...for some odd reason on my consoidation sheet, all the data is beng transfered but when the macro consolidates the data from the other workbooks, it is removing the "header fields" and all other text above row 13 on the "2012" consolidation sheet....any thoughts why?
thx u once again for ur allstar help.
The macro was clearing it, i changed the clear portion to only clear the bottom of the file, not the headers
Please Login or Register to view this content.
hello
thxs for your wonderful help..i really appreciate all your feedback...it works like a charm now.
one query....i have the following macro filters ...however in my consolidation sheet, it does not filter by my criteria in cell C7 or named range "link"
any idea why it is not sorting?
i truely appreciate your help sir.Please Login or Register to view this content.
you might need to open a new thread on this one, i dont know if ill be able to help with it till monday.
hello DGagnon,
thank you for your helpand update. please let me know if you know what the issue maybe with the filter
thx u sir!
hey dgagnon
any thoughts you have on this? thx u sir
sorry i dont have much experiance with Filter via VBA, might be best to start a new topic and get one of the experts in on it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks