Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy non blank rows only
I'm working with Excel 2003. In a workbook I have Range A50:H51 and I need
to copy only the row that has data into another workbook (both rows could have data or only one of the twol). The way my macro is running now, it copies the entire range and will leave a blank row in the other workbook. I am hoping someone can help with code to correct this problem. Thanks! -- Linda |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy non blank rows only
As ALWAYS, post your code for comments. You may want to use
datafilterautofilter on the non blankscopy/paste -- Don Guillett Microsoft MVP Excel SalesAid Software "mathel" wrote in message ... I'm working with Excel 2003. In a workbook I have Range A50:H51 and I need to copy only the row that has data into another workbook (both rows could have data or only one of the twol). The way my macro is running now, it copies the entire range and will leave a blank row in the other workbook. I am hoping someone can help with code to correct this problem. Thanks! -- Linda |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy non blank rows only
The data Range A51:H52 has already been copied from another range to remove
formulas (Paste Special). I tried Auto Filter, Advanced Filter, etc., however, if row 51 is blank, I still get the blank row. In my original code, I was sorting the data so the blank row would be at the bottom, however, as it will not filter, or when copied to the other workbook and if I use End/Down and it skips the blank row, I have to assume Excel sees something in the cell. -- Linda "Don Guillett" wrote: As ALWAYS, post your code for comments. You may want to use datafilterautofilter on the non blankscopy/paste -- Don Guillett Microsoft MVP Excel SalesAid Software "mathel" wrote in message ... I'm working with Excel 2003. In a workbook I have Range A50:H51 and I need to copy only the row that has data into another workbook (both rows could have data or only one of the twol). The way my macro is running now, it copies the entire range and will leave a blank row in the other workbook. I am hoping someone can help with code to correct this problem. Thanks! -- Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy to filtered blank rows from another spreadsheet | Excel Discussion (Misc queries) | |||
Copy several row headers to rows (blank) below for each header | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Copy data from above rows in cells are blank | Excel Programming | |||
Copy rows, but exclude blank rows | Excel Programming |