J
James
Can you please show me how to perform the following in Excel, I am not an
Excel Programmer. I would like to have a command button that calls a
subroutine that
takes two parameters (orglevel2name and status.)
sub Copy_Contents(orglevel2name as string, status as string)
The routine needs to loop through a worksheet called "detail"
The routine needs to loop through column p starting in row 4 until the end
and compare the value of the cell to value of orglevel2name. If the value is
the same it then needs to get value from column i (same row) and compare to
status value. If that is also true it then needs to copy the row from column
a to column t to another existing worksheet called "detail_format"
Can you please show me the syntax to reference the source sheet "detail",
loop though the column, get the value of the cell and copy to the destination
sheet "detail_format"
Thanks
Excel Programmer. I would like to have a command button that calls a
subroutine that
takes two parameters (orglevel2name and status.)
sub Copy_Contents(orglevel2name as string, status as string)
The routine needs to loop through a worksheet called "detail"
The routine needs to loop through column p starting in row 4 until the end
and compare the value of the cell to value of orglevel2name. If the value is
the same it then needs to get value from column i (same row) and compare to
status value. If that is also true it then needs to copy the row from column
a to column t to another existing worksheet called "detail_format"
Can you please show me the syntax to reference the source sheet "detail",
loop though the column, get the value of the cell and copy to the destination
sheet "detail_format"
Thanks