Hi Guys,
I got the below code off another website and it works great for what it does but I'm looking at expanding it to copy off multiple spreadsheets ranging down a new page.
Everything I've tried to use hasn't worked for me and I'd appreciate it if somebody could assist me.
Any help with this would be greatly appreciated.
Please Login or Register to view this content.
Last edited by arlu1201; 08-20-2013 at 01:14 PM. Reason: Use code tags in future.
Hi, wdwinterfang,
please use code-tags when showing your procedure here for better readability and ease of copying/understanding.
Maybe only change the Sheet to work with from a given one to ActiveSheet and check if the active sheet is not the one to copy to?
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger,
Thanks for trying still not working the way I want.
If you refer to the attachment what I'm trying to do is copy everything from the first 5 sheets into another sheet if there is a value in column B.
But only if there is a value in column B and I need the headings to copy over so that I know what area it's for.
Thanks again.
Hi, wdwinterfang,
maybe this is what you are looking for:
Ciao,Please Login or Register to view this content.
Holger
Thanks Holger, works great.
Had a slight problem with this. As it's copying a Formula it's altering the Formula for the sheet and needs to not do that. Is there anyway to get it to paste>Special>values?
Hi, wdwinterfang,
maybe instead of
which is copying the area usePlease Login or Register to view this content.
which should copy only the values.Please Login or Register to view this content.
Ciao,
Holger
Sorry mate didn't work.
Hi, wdwinterfang,
sorry but I forgot that there was a range to handle (I just noticed the first line to deal with copying).
Please try
instead ofPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Thanks mate worked perfectly... your a genius Holger...
Just a question that could help with a problem I'm having. How would I set this up to Paste Values instead of pasting the formula I'm using over?
Hi, wdwinterfang,
doesn´t
do that: paste values?Please Login or Register to view this content.
Ciao,
Holger
No mate it doesn't seem to. Some of the sheets are copying over right but others aren't and I can't seem to work out why.
Hi, wdwinterfang,
the given code just pastes values, no chance for formulas. Maybe you can attach a workbook which features both values as well as formulas to have a look at (or try clearing the contents from To Pick prior to running the macro).
Ciao,
Holger
Holger,
I've attached the file with data on the sheet it seems to be stuffing up on the most. If you run the macro it should show you what I mean if you look at the Avofresh sheet. It copies the top 3 names and the numbers in the row. by the look it leaves the formula which recalculates and pulls in the incorrect data.
Hi, wdwinterfang,
the code inside that workbook still features the copy command so that formulas could be copied over:
You would need to replace that line withPlease Login or Register to view this content.
and check again.Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks