Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to paste to other sheet
I was wondering if someone could help me with the following. I have a excel sheet that is sorted. I need to save this as a cvs file, bu because it is sorted it results in garbage. I think the way around i is to cut and paste each row to another sheet. I am not familiar wit macros and cannot get it to work. I have to paste 4000 rows fro column A to D from one sheet to antoher sheet. Any help is appreciated. Regards ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to paste to other sheet
select range to save in the csv file copy paste/special/values into a new workbook save this one as csv (to save only active sheet.... press ok) it should work. your first file was scrapped due to formulas/filters o some special stuff not because of sorting ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to paste to other sheet
Thanks for replying. I tried your suggestion, but it does not work. still think it has to do with the sort. When I paste (even using you instructions) I get a completely different order and some rows do no have item numbers etc. The reason I think it is because of the sort i because in the original file there are missing row numbers (ie ro 1,2,11,13,15 etc.). Any other suggestions ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to paste to other sheet
What does "rows are missing" mean?
If that means the row numbers along the left hand side are missing, then you've got hidden rows. (Either via a filter (data|filter) or just hiding the row (rowheight to 0).) If you want to not save those hidden rows in your .csv file, you could copy the visible cells to a new sheet and save from there. Select the range edit|goto|special|visible cells only copy (and then paste to that new worksheet and save from there). pmunster wrote: Thanks for replying. I tried your suggestion, but it does not work. I still think it has to do with the sort. When I paste (even using your instructions) I get a completely different order and some rows do not have item numbers etc. The reason I think it is because of the sort is because in the original file there are missing row numbers (ie row 1,2,11,13,15 etc.). Any other suggestions? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy paste Macro in a Protected Sheet | Excel Discussion (Misc queries) | |||
Use macro(command button) paste special in 2nd sheet | Excel Worksheet Functions | |||
Macro - copy a range and paste it in a new sheet 12 times | Excel Worksheet Functions | |||
Copy and Paste Macro for front totals sheet | Excel Discussion (Misc queries) | |||
Change macro to paste as last sheet | Excel Discussion (Misc queries) |