PDA

View Full Version : Copy paste



tinamishra
08-28-2019, 08:27 PM
i will place the vba code in shalu.xlsb
all files are located in same path
sheet name can be aything
open the file
copy all the data from sheet1 and sheet2 of shalu1.xlsx and paste the data to sheet1 of shalu2.csv (sheet name can be anything )
close and save all the file

snb
08-29-2019, 12:47 AM
Assignment #3 ?

tinamishra
08-29-2019, 06:27 AM
Means i play with this file daily so i wanted a macro of the same

pike
09-01-2019, 06:43 PM
the same assignment ?
https://www.mrexcel.com/forum/excel-questions/1108504-delete-entire-row.html
http://www.vbforums.com/showthread.php?878151-Delete-row-by-vba
https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1222571-delete-row-by-vba

pike
09-01-2019, 10:51 PM
and
http://www.excelfox.com/forum/showthread.php/2359-Delete-row-by-vba

tinamishra
09-01-2019, 11:52 PM
Sorry Sir i am new to forums so i dont know the rules now i am aware of it and in future this mistake will not be repeated

pike
09-02-2019, 01:22 AM
LOL ,,, wow are these all yours ?
you could have set a record for the most coss-post ever,,, are there any more?

https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1222571-delete-row-by-vba
http://www.vbforums.com/showthread.php?878151-Delete-row-by-vba
https://www.mrexcel.com/forum/excel-questions/1108504-delete-entire-row.html?highlight=Delete+row+vba
http://www.vbaexpress.com/forum/showthread.php?65786-Copy-paste
http://www.excelfox.com/forum/showthread.php/2359-Delete-row-by-vba
https://chandoo.org/forum/threads/copy-and-paste.42454/
https://www.teachexcel.com/talk/3788/conditionally-delete-entire-row+&cd=3&hl=en&ct=clnk&gl=au

you better read this https://www.excelguru.ca/content.php?184