Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy paste non empty data
Hi,
I have a column where names are entered (column A) and then some value are entered and in column Z, the sum of all the values entered i displayed.... I was wriring a macro to copy the non empty cells in column A, and i is working fine(select the first cell and do a end down selection)... i am facing difficulty in writing code to copy the non empty cells i column Z, this is because the cells have a sum formula and the no empty... please help... Also, If i want some code to run if A1 is non empty, then what shoul be the code like -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy & paste data | Excel Discussion (Misc queries) | |||
Copy/Paste Macro using large amount of Data | Excel Discussion (Misc queries) | |||
1 Create a macro to Copy & paste certain data to another sheet | Excel Discussion (Misc queries) | |||
Special Paste to Next empty row if new data and mark copied Macro | Excel Discussion (Misc queries) | |||
Macro to Copy/Paste Data into one wksht, skipp one row before past | Excel Discussion (Misc queries) |