Evening all,
I am pretty new to VBA and I could really do with some help with a spread sheet.
I need to copy data from multiple rows (I only need up to offset 0,10 from these rows) when a cell in the range A1:A30000 in the sheet entitled DATA equals the value of TextBox7, to another sheet entitled REVIEW.
The sheet entitled REVIEW is same structure (column headings) as the sheet entitled DATA.
When the data is pasted on the sheet REVIEW I need the first row to be entered on the next empty row then each consecutive row entered after that to be entered on an empty row.
I can’t seem to get any variation of VBA code to do this.
Any help will be greatly received.
I am pretty new to VBA and I could really do with some help with a spread sheet.
I need to copy data from multiple rows (I only need up to offset 0,10 from these rows) when a cell in the range A1:A30000 in the sheet entitled DATA equals the value of TextBox7, to another sheet entitled REVIEW.
The sheet entitled REVIEW is same structure (column headings) as the sheet entitled DATA.
When the data is pasted on the sheet REVIEW I need the first row to be entered on the next empty row then each consecutive row entered after that to be entered on an empty row.
I can’t seem to get any variation of VBA code to do this.
Any help will be greatly received.