Fantastic mate, i have complex worksheets, lots of data, on a famous project and it was doing my head in, never understood,you have saved me loads of grief...thank you Rob
Hello! What if the column A numbers are based on a formula. How do you copy formulated values to a different column to just values without the formula? Thanks!
great, but how can I permanently copy the values. Like I want to delete the column from where you take the value. (the pasted cell only show what is in the copied column, it don't have its own values. I want to delete the copied column and want the pasted values as its own values). Thank you for the answer.
I noticed all videos show copying the same info..i dont see the cells having different info copied and pasted in filter cells. So if I copied 5 different cells and want to paste it in a filter spreadsheet, I cant. It only paste the first cell and the other cells dont appear.
Sir, how I can copy selected filter data range and paste to sheet2 using macro into next available empty rows, I’m updating daily translation in order to complete month data 🙏🏻thank you.
Hi there! This is very helpful but is there any way to do this when the filtered cells have all different data? In your examples you are changing them all to the same date/same item name.. what if all the data you need to copy is different?
select your range of cells. When you use the go to special command there is an option to find cells that have formulas in them. copy and then paste as values.
Doug H what I do is, go to visible cells only, then copy the formulas, then when I try to copy again to paste as values, I receive a message of error. I only want the filtered rows to be pasted as values as the rest of the rows contain a running formula that is useful. What the column is doing is pasting actual sales by week when available in different tab via lookup if not a formula multiplies last year sales for a growing rate undefine in another cell.
Please help me I wanna paste my selected column to a filtered column. For example: i Have a column that has different kinds of names and i want it to be paste beside my filtered column so that each side corresponds to the name and if I unfiltered it, I want it to fit to their specific cells. Another example: i have a yellow marked cells and if i filtered out all the yellow cells, i want the names to be paste beside that filtered yellow mark so each yellow mark fits to their specific names. It is not appearing completly every time I paste it beside the filtered section.The names wont come out completly or it appears half of the names i copied and if i unfiltered it the names are completly scattered inside the column and the names wont match to the cells or column that i wanted it to be. Please help me it will save me a lot of time and work. I'm copying and pasting it manually for more than a thousand cells everyday and it is really time consuming and it is hurting my hands so bad. Thanks in advance i hope you guys can help me! Sorry for my english I really cant explain it well.
I rarely post on youtube but this video tutorial deserves a big thank you!
Hi MSC, thanks for the kind words!
Fantastic mate, i have complex worksheets, lots of data, on a famous project and it was doing my head in, never understood,you have saved me loads of grief...thank you Rob
You’re welcome!
This literally just changed my entire life!!!!!!!!!
Thanks Robyn Jungers, glad it helped!
bro.. you saved my life.. thank you soo soo much.. may god bless you !!
Happy to help!
wow. thanks for sharing skip blank features. Its good to see you back on windows ):
Hi Haider Ali, thanks for the comment!
Hello! What if the column A numbers are based on a formula. How do you copy formulated values to a different column to just values without the formula? Thanks!
Thanks this was so helpful!
Glad it was helpful!
Tanks alot! Very special class.
Glad you liked it!
great, but how can I permanently copy the values. Like I want to delete the column from where you take the value. (the pasted cell only show what is in the copied column, it don't have its own values. I want to delete the copied column and want the pasted values as its own values). Thank you for the answer.
First tip is nasty good shit dude
🤭👍
This was incredibly helpful. Thank you
Glad it was helpful!
Please, how to do the same thing :
1- first from another sheet
2- second copy cells with formula and want just value of course with filtered cells
maybe paste special may give some insights ruclips.net/video/q8tzLp5qeHo/видео.html
Thanks a lot! It saves our lives :)
Glad it helped!
Sir u r a genius
Hi Arka Chakraborty, thanks for the kind words!
I noticed all videos show copying the same info..i dont see the cells having different info copied and pasted in filter cells. So if I copied 5 different cells and want to paste it in a filter spreadsheet, I cant. It only paste the first cell and the other cells dont appear.
Hi Ms. Bee, thanks for the comment
@@DougHExcel He wasn't giving you a compliment...
Exactly. Copying with the same value cell is achievable, but how about different values in filtered cells, were you able to figure it out?
@@yuniszahr937 I am wondering this too!
please tell me there’s a setting to just make sheet formulated this way. I have been losing data for years.
Very helpful - thanks!
Glad it was helpful!
Saved me, Thank you!
Glad it helped!
Thank you so much you saved a life 😘
No problem 😊 Glad it helped you!
Bro..... Thanks a lot..... ❤
You're welcome 😊
Thank you for the information
You bet!
Thank u it helped me
Thanks Hitesh Bhatia, glad it helped!
Is there a way to do this when they aren’t in the same workbook your pasting to with the filters
When selecting, and CTRL C should just pick up the filtered items. To make sure ALT+; and then paste to other sheet
Sir, how I can copy selected filter data range and paste to sheet2 using macro into next available empty rows, I’m updating daily translation in order to complete month data 🙏🏻thank you.
You might want to try Power Query. Here's a playlist to explore ruclips.net/video/712mV9jwMLo/видео.html
Hi there! This is very helpful but is there any way to do this when the filtered cells have all different data? In your examples you are changing them all to the same date/same item name.. what if all the data you need to copy is different?
maybe try Find All and then copy or use Goto Special for some ideas
ruclips.net/video/lyqxF6J28rk/видео.html
ruclips.net/video/YsVE6KhUwYA/видео.html
That's great. Thank you very much.
You’re welcome
I have formulas in a filtered range, and want to select those, and paste as values. Is there any way to get that done?
select your range of cells. When you use the go to special command there is an option to find cells that have formulas in them. copy and then paste as values.
Doug H what I do is, go to visible cells only, then copy the formulas, then when I try to copy again to paste as values, I receive a message of error. I only want the filtered rows to be pasted as values as the rest of the rows contain a running formula that is useful. What the column is doing is pasting actual sales by week when available in different tab via lookup if not a formula multiplies last year sales for a growing rate undefine in another cell.
*i define in another cell
Please, how to do the same thing first from another sheer ,second copy cells with formula and want just value
Thank you!!!
You're welcome!
Thank you :)
No problem 😊
Merci beaucoup
De rien
Thanks a lot.
Most welcome!
Thanks 🙏
You’re welcome 😊
You saved me
Glad to hear that!
Please help me I wanna paste my selected column to a filtered column. For example: i Have a column that has different kinds of names and i want it to be paste beside my filtered column so that each side corresponds to the name and if I unfiltered it, I want it to fit to their specific cells. Another example: i have a yellow marked cells and if i filtered out all the yellow cells, i want the names to be paste beside that filtered yellow mark so each yellow mark fits to their specific names.
It is not appearing completly every time I paste it beside the filtered section.The names wont come out completly or it appears half of the names i copied and if i unfiltered it the names are completly scattered inside the column and the names wont match to the cells or column that i wanted it to be. Please help me it will save me a lot of time and work.
I'm copying and pasting it manually for more than a thousand cells everyday and it is really time consuming and it is hurting my hands so bad.
Thanks in advance i hope you guys can help me! Sorry for my english I really cant explain it well.
maybe this video will give an idea ruclips.net/video/wHgv_gWw7iQ/видео.html
I'm having the same problem man, if you did find the solution please share it with me, thank you.
1:41
THANK YOUUUUUU
You're Welcome!
Good one sir
Very very impressive thing u explained in such a good way😈😈😈😈
Thanks HARISH PAL DHIR!
Good one
Thanks Frederick O. Anaafi!
NICE
Thanks!
It works but it does not alow me to edit text in pasted cells
Emir Dzibric, that is very interesting...thanks for letting me know.
what i do than i have diffrant value in every cells??
Hi +Patidar Ramesh, sorry I don't do consulting :-( ....but try to post on the mrexcel.com forum!
doesn't work !!
do not copy or record messages, messenger. do not record phone calls.. where is the private and respect.
Sorry, don’t understand the comment/ question...
Really helpful video thank you!
Glad it was helpful!
Thanks a lot.. Sir
Most welcome!