I have a range of d1:p15 and I need to copy any column within that range if the value in cell 15 of that column is greater than 0, and paste it to the next available column in another sheet. it seems simple enough but I cant get it to work without copying every column if there are any cells in row 15 greater than 0. any ideas
Last edited by gherzberg; 09-25-2012 at 09:28 AM.
attach please a sample file
If solved remember to mark Thread as solved
Hi, gherzberg,
something like this may get you started:
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
okay the range that needs to be copied is on the DaY sheet, needs to be copied to the wsh day sheet.
Hi, gherzberg,
Values of 0.00 or blanks shall not be copied, maybe adept the code to:I have a range of d1:p15 and I need to copy any column within that range if the value in cell 15 of that column is greater than 0...
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks