G
Guest
Hi everybody,
I am working on a macro to help automate some of the tasks being done to a
group of spreadsheets that are updated often. I can email a dummy workbook to
illustrate what I am talking about if necessary, just let me know.
My workbook contains 2 ranges of data, the first contains a table of values
and within this table are the target rows. This first range varies in size
both in number of Rows and Columns which is where I am having one of two hang
ups.
The second Range is located to the right of the first range and is always 3
columns wide. Its number of rows is variable and can be as long as the first
range but not longer. The two ranges are separated by 2 blank columns,(for
example Range 1A6:J45) Range 2M6:O32)), and both start on row 6.
What I would like the macro to do is this. Search through the "B" column of
the first range to find a target row by finding the cells with "TargetValue1"
and "TargetValue2". Once a target row is detected I would like to delete the
Row ut only within the first range, and Shift the Cells Up.
Thank you all for any guidance,
I am working on a macro to help automate some of the tasks being done to a
group of spreadsheets that are updated often. I can email a dummy workbook to
illustrate what I am talking about if necessary, just let me know.
My workbook contains 2 ranges of data, the first contains a table of values
and within this table are the target rows. This first range varies in size
both in number of Rows and Columns which is where I am having one of two hang
ups.
The second Range is located to the right of the first range and is always 3
columns wide. Its number of rows is variable and can be as long as the first
range but not longer. The two ranges are separated by 2 blank columns,(for
example Range 1A6:J45) Range 2M6:O32)), and both start on row 6.
What I would like the macro to do is this. Search through the "B" column of
the first range to find a target row by finding the cells with "TargetValue1"
and "TargetValue2". Once a target row is detected I would like to delete the
Row ut only within the first range, and Shift the Cells Up.
Thank you all for any guidance,