Hello, this is for learning purpose...Thanks in advance for any help
I have 2 worksheets
sheet 1 = "Original"
sheet 2 = "Duplicate"
in Original Sheet, I have data from A1 to E11
I have only two values in the cells 0 and 1
What I need to do is this
Select A1 in Original Sheet
Select All adjacent cells (all non blank cells)
if in that range, in each cell value is 1
then copy only those cells
Go to Duplicate sheet
paste those 1 in respective cells
Can you help me to write a simple code for this? a sample data sheet is attached.
Thanks again.
Bookmarks