Grab the file I used in the video from here 👉 pages.xelplus.com/vba-copy-resize-file

Let me be very frank with you Leila. I am an ardent viewer of many videos on VBA. if ever there is somebody who does the explanations in such a marvelous way, It's YOU...No other people. Man, you are just awesome. Hats off, God bless you.

@sakhilengwenya594

Ай бұрын

Me two. I love her work

Thanks for the Copy Paste VBA Fun!!

@LeilaGharani

6 жыл бұрын

Thank you very much Mike :)

love your tutorials so much, indeed you are an an expert

Leila vba é outro nível, show de conteúdo.

Wow! Another great tutorial, thanks Leila!

Leila, has anyone told you lately how awesome you are? You are the best! It's the first time I've understood the resize range expression. Your explanation is so clear. Thank you very much.

Great Video Leila- really enjoying these videos! Great info :)

Very helpful and useful. Thank you.

I find myself digging into your videos more often than before. And thank you for this tutorial, I was able to shorten the macro I recorded. 😀

@LeilaGharani

Жыл бұрын

Glad I could help!

@hamphrey.olendo65

Жыл бұрын

@@LeilaGharani kindly is there excel formula to copy special values from one cell to another?, in such that when the initial cell is updated, the copied cell doesn't change

@hamphrey.olendo65

Жыл бұрын

@@LeilaGharani hi leila, kindly is there excel formula to copy special values, without using vba?

Hi Leila , you make it so simple, thanks for the short video, very keen to learn more VBA, thanks

@LeilaGharani

3 жыл бұрын

Happy to hear that!

Magic! So well explained!

. (Love your hands & nails, and this color is the best for them 💖💖💖💖) . Im glad I discovered your channel. Am a programmer (COBOL, Java, C++, you name it), but only now am I needed for Excel/VBA projects, so I'm watching all of your videos. .

LEILA, U R GR8!

Helpful Thanks for the vedio Leila

Crystal clear!

You made it so simple. That's great

@LeilaGharani

4 жыл бұрын

I'm glad to hear that :)

Very well explained.Thank you so much mam🙏🙏🙏🙏🙏

Explained very good. Thanks!

@LeilaGharani

6 жыл бұрын

You're very welcome. Glad you like the explanation.

Its looking so simple in this video than actually it would be..thanks a lot leila..will waiting for more on this..

@LeilaGharani

6 жыл бұрын

Thanks Ajay. It does get easier the more we practice :)

thank you so much Ms. Leila you are great appreciated

@LeilaGharani

6 жыл бұрын

You're very welcome Ismail.

Thanks a lot Madam, Keep up the good work.

thank you, its very helpfull for me

Thanks leila. This was very interesting :)

@LeilaGharani

6 жыл бұрын

You're welcome John :)

a very instructive tutorial, thanks

@LeilaGharani

Ай бұрын

You are most welcome!

Leila u teach so well😭 im ur big fan

@LeilaGharani

5 жыл бұрын

I'm glad to hear that.

Thanks for the video ma'am....nicely explained...loved it! 😊

@LeilaGharani

6 жыл бұрын

You're welcome Mohit :)

Thank you very much.

Great Video... thumps up!

Thanks for received in your valuable tricks .

@LeilaGharani

6 жыл бұрын

You're welcome Sivarama.

hi leila(excelwoman),as usual, your simple method learning is very usefull. thanks for sharing your excel knowlege.looking forward your next lectue.

@LeilaGharani

6 жыл бұрын

Thank you Mohammad. I'm happy you like the teaching style. Next VBA video will be up next week :)

THANK YOU!!!

Thanks for helping me with work 👍

@LeilaGharani

3 ай бұрын

🙏

One more thing U concentrate on the points thar matters And usefull to daily tasks Thanks for making excel peace of cake Thanks leila

@LeilaGharani

6 жыл бұрын

Thank you! Really appreciate your support of all the videos.

Hello Leila thanks a lot for the video, i wonder if you can do copy from multiple worksheets and pastespecial values to a single worksheet

Hi Leila ! Your video is great. I need your help on how to copy paste data into a table format. I need to add it at the end of the table and with your method it always return an error...

Thanks!!!!!!!!!!!!!!!

I always learn a lot from your videos..Thank you so much.I have a question about currentregion,is there a way to copy paste just a few rows or columns that acts like currentregion "to be dynamic" you're the best

Thank you :)

@LeilaGharani

Жыл бұрын

That's very kind, thank you!

What if we want to copy paste with cell dimensions (Row Height, Col Width, Merge, Picture etc) as we do mannually using fomat painter on clip board

Thanks

@LeilaGharani

Ай бұрын

Thank you!

Thanks!

@LeilaGharani

Жыл бұрын

Thank you so much!

best of the best..........

@LeilaGharani

6 жыл бұрын

Thank you! Glad you like it :)

awesome

well done

Leila...great tutorial.I have a question.On sheet1 I have a table W8:AA450.I want to bring data from this table to sheet2 in a fixed range A4:A8,one row at a time.Because for each row of data from sheet1 table ,I'm doing some calculation on sheet2.Can you make a video or reply here thx.

What if you have formulas in the range and are using iferror to make them blank? I'm trying to only copy the cells with text from the formulas and this method works but it's copying all the cells with formulas in them.

Hi Leila is there a non-vba solution were you can convert formulas to values in cells which are associated with dates past a certain date?

Thanks mam Nice Video

@LeilaGharani

6 жыл бұрын

You're very welcome Khalid.

thanks thanks thanks

Terima kasih.

@LeilaGharani

10 күн бұрын

Thank you! Glad our content is helpful!

Merci

Thank you very much! Could you please give the code for copy-paste a table that to a specific cell on another sheet (i.e.: Print? NB: That latter sheet has information such as Name and signature, and date of order. This sheet has to be printed

How to auto squeeze weekends column up to 0.8 width for all year? The date is 11/05/2021 on the top the column. I need squeeze like ## size for them.

When I copy with paste special, it deletes my conditional formatting (color coding). Am I doing something wrong?

Any way to actually find all cells in a sheet with same value and repliacte the cell formatting across all whenever its changed on any of those cells.

Leila, I enrolled myself for your VBA course today. Meet you there.

@LeilaGharani

6 жыл бұрын

I hope you find a lot of value in the course for your work! Thank you for your support.

@sandeepkothari5000

6 жыл бұрын

Welcome.

Hie Leila The video was awesome In the same way can we copy (fixed range) to paste special (in dynamic) only after giving command.

Hi Leila thank you for your videos. Do you have or have any plans on how to migrate data from one excel workbook that is in one carpet to another workbook in another carpet ? Let's say that I have monthly reports and I want to consolidate them all in just one sheet. Thanks !

@LeilaGharani

6 жыл бұрын

Yes - I cover these in my VBA course. I will try and add one of the videos to KZread as well in the next weeks...

@Disaenz10

6 жыл бұрын

Leila Gharani awesomeee, please let me know when you upload it. Thanks!

Hi I have a list of names in a column I need to apply filter for each names and copy the related data of names ,how to do that in VBA code pls share the code

What if the data has broken rows i.e if the data is spread in different rows and few rows are blank in between. Will current range work?

hi can you tell me how can we to print userform fit to paper ..pleas

can you show how to loop the selection

I want to copy data from multiple sheets in a workbook and paste it to one sheet in other workbook. It would be great if anyone can help

Hi, how do I resize a chart width using offset and counta with vba? Pleas help me

So how do you copy a range from one workbook to another using Control C to copy the range, then go to the sheet you want to paste into and click a paste button that does a PasteSpecial on the values? it seems I can make this work with an unlocked file, but when I lock it down, it will not let me paste through the macro button.

Please share how we can copy only the rows that fulfil a certain criteria.. thanks

Hi Ms. Leila. I would just like to ask if it's possible to copy paste data on a spreadsheet even if the file is in a view mode only? My teammates and I are having a hard time working using this file because we have to manually look at the items, copy and paste it on a separate sheet so we cannnot vlookup the items. We manually click ctrl + f then ctl + c & p instead. Your helo would be very valuable to us. Thank you!

Your way of teaching is amazing madam thanks for given such good VBA videos class and teaching.

@LeilaGharani

6 жыл бұрын

You're very welcome Praveen. I'm happy you like the videos and the teaching :)

Hi Leila, need a small help, actually i need to copy data from one worksheet to another only when the headers of both worksheets match. i have written a code which is actually copying the entire range from one worksheet to another but actually the situation is, once the headers match, the data gets copied and then next time the data should get copied skipping one row in destination worksheet. please help

Very interesting lesson. I would like to ask you if you can prepare tutorial - how to use excel formulas in VBA?

@LeilaGharani

6 жыл бұрын

Glad you like it. Ok - will add this to my list. Thank you for your suggestion.

Hi, If I run VBA of Paste special method. The pasted column Turns into a text. Could you Please help me to covert the pasted column into number format in VBA itself?

its a great tutorial, but what if, i want to copy and paste my data to a template that doesn't allow copy paste, well in such a case we have to link name ranges, or cell references, isnt it? or is there any good way then this

@LeilaGharani

6 жыл бұрын

If the sheet is protected, you can un-protect in the macro before pasting and then re-protect. If you are using named ranges, you can reference that directly in the macro. This video shows different ways of writing to ranges: kzread.info/dash/bejne/k5d7rMRyf9LQmNI.html

Hi Leila, Need you help, it is possible to export entire excel file with same data and formats but not formulas. i have a file has charts, pivots, report dashboard with sources data but i dont want to share this file with formulas.

Hello Leila, I am wondering if you can help me with the following task: I have two work books, the first one is to create invoice with customer information and purchasing details , the second workbook is to save dynamically the data including the invoice number , date, total price ..etc. extracted form the first workbook . At the end of the day I am going to save both workbooks and shut down the computer . what I would like to have the next day is when I open the first workbook , I want to open the second workbook using a command button on the first workbook , also I want to be able to get the last invoice number saved in the second workbook to be transferred to the first workbook with adding one to it . the invoice numbers are saved in column A2 :A in the second workbook. the invoice cell number is L11 in the first workbook . I have created a command button on the first workbook to open the second workbook , that is successful , but I am not able to write the correct VBA code to transfer the last row cell value of column A from second workbook to the first workbook . Can you please help me ? thanks Issam

Hi leila, Is there a way to copy and paste missing information from 1 column to another by match.?? Example: colm1 column 2 123 a 342 342 c 123 Automatically copy missing carctrs a & c wher they belong.

Hi Leila, can you please tell me how can I paste in only UN HIDE cells in excel (the visible ones)? Alt; only works for copy the visible cells not for paste in visible ones. Thank you!

@farzanmoha8935

5 жыл бұрын

Does anyone know the answer?

👌

If you have please recommend the video, about Excel Vba paste special value if looking or finding Todays value . 💚💛❤️

How to auto repeat paste special at each interval of time

👍👍👍

I need your help about VBA, will you do please, when you free time ?

how can i use a formula to a table without loop in vba , for example i want to replace a array 1 ,5 , 6, 8 by the same array + 4 : 5, 9, 10, 12

Hey, In your Video you didn't manage how can I Past all Tablle + Color about the table but as a Value. SO I want to keep the color and point as a Value

Hi Ma'am, I have a question. How can we copy paste a data which has data+images.?? If we are working in one Excel and there is data+ images ( just like BOQ or quotation) so how can we copy or paste the some data ? Because sometimes what happens that the images do not copy well in format. So need solution please.

How do I copy a cell into another cell if its blank using VBA macro?

How to browse a folder or files via Excel VBA, copy the name and paste it in a specified 'word' file??

How can this be applied from a different sheet? What needs to be modified? I'd like to cut the datasource and paste it to a different sheet.

@LeilaGharani

5 жыл бұрын

The worksheet name needs to be added before the range reference. This is something we cover in detail inside the course - I'll add it to my list to put out some videos on this topic for KZread.

I need code to collect data from different workbooks books in folder and copy each relevant sheet in master file. I have three different file in folder and have 3 works sheets in each file. I need to loop through each file and copy relevant sheet to relevant master file. Than data from next file to master workbook. Waiting for reply, please Naeem

Hello I am trying to find an vba code to copy and paste every range of rows like(A1:C19).copy and paste in word file as image then copy from (A20:C39) and paste in the same word file and so on for the rest of the table in excel. they have told me that I need to use the looping in excel but I don't know exactly how to do it …. please help if you can

how to copy apply after auto filter only particular rows. ex. apply autofilter only first 4 rows copy. Please give me answer.

@LeilaGharani

6 жыл бұрын

To copy only visible rows in the autofilter, you can use this code: ActiveSheet.AutoFilter.Range.Copy

how to copy bulk records with copy and paste specials with macros, its only copying 900 records maximums

One very important questions raises here!! Is it possible to copy different ranges from different sheets and paste them in a specific range?!

@LeilaGharani

6 жыл бұрын

Hi Abdullah - yes - you just have to put the sheet name before the range - you can do this for example by Worksheets("Source").range("A4").currentregion.copy and paste it in another sheet, by mentioning the sheet name before the range. You can also use the code name of the sheet instead of referring to it through the sheets collection.

@abdullahquhtani8058

6 жыл бұрын

Leila Gharani I tried that before but I had to copy and paste two or three times. My question was: Is it possible to copy two different ranges from two sheets and paste those two ranges in a specific range in code. I hope I made it clear. Thank you so much for your cooperation.

@LeilaGharani

6 жыл бұрын

I see - If all your areas are one sheet, you could do it in one line like this: Range("A4:B7,A28:B32,A40:B42").Copy and then paste in one cell. But if your areas are in different sheets, you could use variables for the different areas and then do a loop to copy paste them in the loop. You'll need a variable for the next available row as well.

dear sir I woukd like to learning about excel vba sumif function . please sir.

What about a copy and paste button

For the first time, I was confused by your lesson?

How to copy paste data with specific header name

When I run ?Range("A4").CurrentRegion.Offset(1,0) in the immediate window, I get Run-time error 13: type mismatch. The line of code, "Range("A4").CurrentRegion.Offset(1,0)" is showing RED in the VBE. I also tried running "Application.Workbooks ("Book1").Worksheets("Sheet2").Select" in Workbook "Book1" and I got a runtime error: Run-time error 9: Subscript out of range. Could this be a related issue? Any idea what is going on? Thank you. Robert

@LeilaGharani

6 жыл бұрын

Hi Robert, you need .address in the end.

@dasrotrad

6 жыл бұрын

Leila Gharani THANK YOU!

@LeilaGharani

6 жыл бұрын

You're welcome.

how can I download the workbook for my practice?

@LeilaGharani

6 жыл бұрын

I see - the link is missing - I'll update it in a bit...will let you know.

@sandeepkothari5000

6 жыл бұрын

Thanks.

@LeilaGharani

6 жыл бұрын

The workbook is now available here: www.xelplus.com/vba-copy-paste/ - just scroll down to the bottom of the post.

@sandeepkothari5000

6 жыл бұрын

Thanks a ton Leila.

1. In VBA code, what are arguments to Copy-Paste following: a. “Äll merging conditional formats” option showing in paste special dialogue box; b. paste link; c. Row heights; d. fixed picture & e. linked picture; f. use of camera to copy & paste pictures, images.

@LeilaGharani

6 жыл бұрын

Hi Sandeep - here it's best to use the macro recorder and test each one. This gives you a quick glossary of all the options available - you can copy and paste the code and adjust for your projects.