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
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
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
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
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
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.
I have two sheets - In sheet 1 I will input empID in one cell and have employee name in cell2. Now I want to look the empid in sheet two and update the name to the respective empID in sheet 2. Please help...
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
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....
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???
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
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 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
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???
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.
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, 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?
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
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.
Very well explained, very beginner friendly and concept explained in perfect way, thankyou so much helped me a lot! :)
Welcome
Thank you very much you have saved my company with this video.
Oh......Really......Glad to know that.
To good to understand in a very simple way...thanks for ur help
Thanks and 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
Thank you for this and my small suggestion is while explaining some can you please explain us briefly
I have multiple random data worksheet but I need only specific data from it to be pasted on another worksheet plz help me
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
for any real time VBA Project, you can write to exceldestination@gmail.com
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”?
if we have to copy the cells and paste special then how to program, please inform
let me create a tutorial for that
Sir can we copy dynamic updating data from single cell in range or tabular form
yes on timely manner
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
you can create range for A to H.
for getting help use the following link :
th-cam.com/video/6edvmcCvCkA/w-d-xo.html
Super 💖
Thanks
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
Is it possible same with any formulas?
Thank you for the easy explanation , would you kindly help how to copy only last 20 rows from sheet 1 to sheet 2
How to tackle the empty cells using this vba code. Means if we want to exclude some cells then how to do that
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.
You can take from another tutorial, which is for transposing data. Let me know, if it helps. Link is :
th-cam.com/video/0gBOuf79weM/w-d-xo.html
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 two sheets - In sheet 1 I will input empID in one cell and have employee name in cell2. Now I want to look the empid in sheet two and update the name to the respective empID in sheet 2. Please help...
Hello...If I have a dynamic range to be copied in another sheet, what will be the code? I am unable to solve that.
you can use selection method.
Didnt get it.
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 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
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 ?
Thanks for watching! Yes there are multiple ways of writing VBA Code.
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???
Thanks for watching! If you need any VBA Support\Code, you can approach to exceldestination@gmail.com
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
check the following tutorial :
th-cam.com/video/9EW_5MnJMzo/w-d-xo.html
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...
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
Let me check
@@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
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
It will be helpful
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???
Thank you.
Welcome
Is there a possibility to use checkbox instead of command button to copy in vba form.....
Yes, we can use check box also.
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.
You can use dynamic range through VBA. check this :
th-cam.com/video/6edvmcCvCkA/w-d-xo.html
Hi sir. How to make this for n number of sheets and also repeat for those sheets automatically. Plz help me.
Hi Sir, encountered runtime error 1004 when i used and applied it to an actual file to be copied
check this
th-cam.com/video/-QpqFg6kOPw/w-d-xo.html
Hello Sir,
While copying large data, it always warning wether to save in clipboard. How to disable this warning.
check this code
Application.DisplayAlerts = False
Thanks
Welcome
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
Great Mr.
Very good
Thanks
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?
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?
What if the range is changing?
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
Ager 2x ho muje 2 copy krna he to kese kre sr
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
for any excel vba project, you can write to exceldestination@gmail.com
❤
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.
Nice
Thanks
how to repeated rows X number of time in excel vba
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