|
|
Thread Tools | Display Modes |
#16
|
|||
|
|||
I am ready I started over but it still doesn't copy all columns - it misses the names and the columns after that. Also it is better to copy all the cells - not only visible ones. And if it can copy only the data from these specific sheets - Crawler, Various, MandM, Fragrance, 5£. Because I have other sheets with not formatted and unnecessary data. Thanks a lot for your help. |
#17
|
|||
|
|||
Hi,
I'll look at this tomorrow. |
#18
|
|||
|
|||
Hi,
See if this works for you. |
#19
|
|||
|
|||
Hello!
Yes it copies the names and the hidden columns data It still copies the data from all other sheets too |
#20
|
|||
|
|||
HI
Sorry I miss read your information. I'll make the necessary correction in the next couple days. |
#21
|
|||
|
|||
Thanks very much for your help!
|
#22
|
|||
|
|||
HI,
See if this works. |
#23
|
|||
|
|||
It works! Thank you!
|
#24
|
|||
|
|||
Hi,
I just teased my copy and it does populate the "Summary" sheet. Did you change any worksheet names? If so you must change the code that has the name that you changed. |
#25
|
|||
|
|||
Just edited my last post. The working sheet names are the same. Only it matters if the other sheets are before or after the working ones.
|
#26
|
|||
|
|||
Hi,
Was gone and did not log out. In the code module for select case you will see "Else". In it you will see "Exit Sub" remove it and I think it should work. |
#27
|
|||
|
|||
Hi,
I finally added it to my file successfully! I had to use the export function. I am totally novice at all of this. Thank you again! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
IF Formula - multiple values | Jac_Fcb | Excel | 1 | 03-17-2015 12:41 AM |
Reference another workbook and return values from the same cell across multiple sheets/tabs | lwls | Excel Programming | 5 | 11-08-2014 02:11 PM |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
carry values of various sheets to another sheet | zizao | Excel | 2 | 06-20-2014 12:47 PM |