Thank you very much you have saved my company with this video.

@ExcelDestination

3 жыл бұрын

Oh......Really......Glad to know that.

Very well explained, very beginner friendly and concept explained in perfect way, thankyou so much helped me a lot! :)

@ExcelDestination

2 жыл бұрын

Welcome

To good to understand in a very simple way...thanks for ur help

@ExcelDestination

4 жыл бұрын

Thanks and welcome

Great Mr.

❤

if we have multiple cell to copy to different sheet , eg : sheet 1 i have cell value 1,2,3,4,5 and need to copy at different sheets like sheet "a" cell a1 value =1 from sheet 1 , sheet "b" cell a1 value = 2 from sheet 1 and so on can you suggest any code

can i do this macro changing the copy with the function “cut”?

Thank you for this and my small suggestion is while explaining some can you please explain us briefly

Thank you.

@ExcelDestination

2 жыл бұрын

Welcome

This is easy to understand and thank you very much. My question is that , how to do copy paste if the user defines the destination sheet name in a particular cell and also then number of cells

Super 💖

@ExcelDestination

Жыл бұрын

Thanks

I have multiple random data worksheet but I need only specific data from it to be pasted on another worksheet plz help me

It will be helpful

I have to copy value coming only in row of xx no. Of 7th column As my xx value change position when sheet fetch value from site after every 5 min If i use command to copy perticular (1,1) Change in position of xx in excel gets wrong value of concern xx How to fetch value only cominh after xx

How to tackle the empty cells using this vba code. Means if we want to exclude some cells then how to do that

Hi , very useful video, however i need to know how we can in VBA copy new rows added to a sheet into a new sheet however the rows being copied should not be entire row but just for example A to H, i don't want the entire row to be copied , also the data from A to H should be pasted in a new sheet in a new row each time ...thanks

@ExcelDestination

4 жыл бұрын

you can create range for A to H. for getting help use the following link : kzread.info/dash/bejne/aJmY2M-cc9mpm6Q.html

Thanks

@ExcelDestination

2 жыл бұрын

Welcome

Excellent BUT what if??? IF condition is met then copy a range to an other sheet automatically don't want a command button

I have watched your tutorial with great interest, and intrigue, in your video, the part where you copy a cell range from sheet 2 to sheet 1, is the paste option in the VBA CODE for text only, for example if the destination sheet (sheet 1) is in GREY with BLACK text, and sheet 2 is WHITE with BLACK text, when copying sheet 2 to sheet 1, does the paste option turn the GREY cells or sheet to WHITE with BLACK text? Or does it just paste the text only? As you will know if you copied, and paste manually the destination area or sheet, when you right click on your mouse the paste options appears, and if you only want to paste the text, you will select the second symbol from the left marked 123 for text only option. In my main data base sheet I have set up formatting and formulas which I do not want to alter, so does your VBA code only paste the text only? If not please can you let me know what part of your VBA that will only paste TEXT ONLY, thank you, I look forward to hear from you. With kind regards Steve

@ExcelDestination

3 жыл бұрын

for any real time VBA Project, you can write to exceldestination@gmail.com

hello sir we have use this code but once we click button data is copy ti another sheet but we have again press the button older data repeat in sheet (copy) so please send code not repeat data to copy in another sheet

Hi all i would like to know how to do the same but always find first empty row for paste and do it like multuple time

Thank you for the easy explanation , would you kindly help how to copy only last 20 rows from sheet 1 to sheet 2

hi sir, i am having multiple sheets and wanted to copy each particular cell from every sheet and paste it to a new sheet in transpose manner can we achive that? if having any answer help me please sir thanx.

@ExcelDestination

4 жыл бұрын

You can take from another tutorial, which is for transposing data. Let me know, if it helps. Link is : kzread.info/dash/bejne/Ypt2sdefZ5zdlbA.html

i Wanna ask very important Question, is it possible to copy by selecting from 1000 lines, to required lines like i need to copy line 5, 15, 52,49,99,155,260, 129,30,400,490,600 and past in single click

I want to copy and paste data from one range in the excel sheet to another range below in the same excel sheet, please give me the code to do that...

If first sheet data is having large range, say A2........last row not known , what will be the code for copy and paste in another sheet

I have multiple excel files, from each excel file i have to copy specific sheet and merge it to single file, but while pasting I want only values not all the formats and formulas in sheet....

hi sir, Using too many select and activate statements will slow the macro . Is there an alternative ?

@ExcelDestination

4 жыл бұрын

Thanks for watching! Yes there are multiple ways of writing VBA Code.

Any have formulas or videos, Mere pass ak sheet me data hy with formulas , use multiple sheet me auto uploaded karna hy with everything changes with formulas sum or subtotal etc. Is it possible???? Jayse kisi supermarket ka data hota hy customer wise regiowise codewise subtotal in one sheet that want to auto uploade in multiple sheet Macro me copy paste to ho jata hy lekin with formulas nahi ate total and subtotal You have any suggestions???

sir, i have data in sheet1 a2:a10 and want to generate auto serial number on sheet2 and copy sheet1 data to sheet2 how to make coding simple and can i use the loop for this???

@ExcelDestination

4 жыл бұрын

Thanks for watching! If you need any VBA Support\Code, you can approach to exceldestination@gmail.com

Sir can we copy dynamic updating data from single cell in range or tabular form

@ExcelDestination

3 жыл бұрын

yes on timely manner

Very good

@ExcelDestination

4 жыл бұрын

Thanks

if we have to copy the cells and paste special then how to program, please inform

@ExcelDestination

3 жыл бұрын

let me create a tutorial for that

Is it possible same with any formulas?

Hi Sir, encountered runtime error 1004 when i used and applied it to an actual file to be copied

@ExcelDestination

4 жыл бұрын

check this kzread.info/dash/bejne/X4Wk06igZs61gNo.html

Nice

@ExcelDestination

2 жыл бұрын

Thanks

Is there a possibility to use checkbox instead of command button to copy in vba form.....

@ExcelDestination

4 жыл бұрын

Yes, we can use check box also.

sir plz provide the code so that I can copy & paste in my excel sheet, I am not a programmer but this useful for my other data entry work... plz send

Hi sir. How to make this for n number of sheets and also repeat for those sheets automatically. Plz help me.

How to paste either no of ROWS below or above ? Example I paste 5 items already second time I past it should paste without overwriting the date I have already pasted instead it should paste either below or above no of preferred ROWS kindly explain sir

Hello Sir, While copying large data, it always warning wether to save in clipboard. How to disable this warning.

@ExcelDestination

4 жыл бұрын

check this code Application.DisplayAlerts = False

What if the range is changing?

Hello sir . Thanks for this vedio . I have a question regarding the same if i click same commendbutton2 to 2time so value is replaceing or lr+1 . Please help for this 🙏 questions how to past LR +1.

@ExcelDestination

4 жыл бұрын

You can use dynamic range through VBA. check this : kzread.info/dash/bejne/aJmY2M-cc9mpm6Q.html

Thank you for the video..😊 Is there any way by which we can automate the copy paste exercise from master sheet to different sheets... I mn a selected range or cell will copy and pasted to other sheet and again copy from next row of master sheet and paste to new sheet

@ExcelDestination

3 жыл бұрын

Let me check

@CookingKhiladi

3 жыл бұрын

@@ExcelDestination Any idea on this even I was looking for the same ... Will copy paste few range , later on the other day I need to copy paste from Next cell

Hello...If I have a dynamic range to be copied in another sheet, what will be the code? I am unable to solve that.

@ExcelDestination

4 жыл бұрын

you can use selection method.

@swarnpriyaswarn

4 жыл бұрын

Didnt get it.

Sir I have a question I want to copy one date to next date then copy next date until another date in loop Like in A1 I have 01/05/2020 & in A10 I have 02/05/2020 & A12 I have 03/05/2020. Now I want to fill dates in cell A2 to A9 date 01/05/2020 so on dates are not in same position Plz help me

@ExcelDestination

4 жыл бұрын

check the following tutorial : kzread.info/dash/bejne/a3mLwZeGnq2zqtI.html

if it's possible please help me to do my work easy, its humble request, if anyone know please share the video

how to repeated rows X number of time in excel vba

Sir i have a data having large number of rows and columns. In this data there is a column having a drop down list of serviceability status i.e serviceable or non serviceable. I want that the moment i select serviceable the entire rows having serviceable text copy into another worksheet i.e sheet 2 and when i select non serviceable the entire rows having non serviceable text copy into another worksheet i.e sheet 3. Sir the third and most important requirements is that there is a column having items quantity no in this data. If items quantity is 10 and there is only 06 items are serviceable then is this possible the same row copy in both sheet 2 and sheet 3 i.e in sheet 2 same row will be copy having 6 serviceable items and in sheet 3 same row will be copy having 4 non serviceable items. Sir if this is possible using VBA or without VBA Please share with me. I will be thankful to you.

Ager 2x ho muje 2 copy krna he to kese kre sr

Hello, maybe you can help me, by the way I found your video intrestant, I want to copy and paste but only under certain conditions. I want to paste in worksheet that depends on the number in cell D1, after that he still has to come to the right place, in my excel worksheet I work with Vlookup and indirectly. Could you help me?

@gerardvaneggermond9967

4 жыл бұрын

Hello, I understand the concept, the problem with me is that I want to paste it in the right place, I understand to select the worksheet, but now I want to paste it in the right place, first I want to search for the name after that on paste the names at the bottom and then paste the number, is that possible?

if i wanted to copy and paste a sequence of cells 1000 times or more how do i set that up? I have all my data in the top row. set up every 7 cells. i want to put them in separate rows. for instance (A1,A2,A3,A4,A5,A6,A7,) I want in Row 2. (A8,A9,A10,A11,A12,A13,A14) I want in row 2. and so on for 1000 times or more. can you give me the formula for this? Please thank you

@ExcelDestination

4 жыл бұрын

for any excel vba project, you can write to exceldestination@gmail.com

how to repeated rows X number of time in excel vba