VBA- Cut and Paste based on cell value

[GeorgeYYC]

Friends,

Need a bit of help. I'm a newbie to VBA..

If the value in column A is = Vendor ID, I would like to move the data in the row (A:H) over to column I , but up one row.

Also this will need to loop throughout the workbook.

Thank you,
George

 

[mumps]

In which row in column A does your data start? By "loop throughout the workbook" do you mean loop through the entire single sheet or loop through all the sheets? I assume you are looking for the string "Vendor ID" in column A. Is this correct?

 

[GeorgeYYC]

In which row in column A does your data start? By "loop throughout the workbook" do you mean loop through the entire single sheet or loop through all the sheets? I assume you are looking for the string "Vendor ID" in column A. Is this correct?

Hello,


- My data will start in A(
- It can loop through just the sheet
- Yes I am looking for the string Vendor ID:

Thank you!

 

[mumps]

What does A( mean? If your data starts in row 2, does row 1 have headers?

 

[GeorgeYYC]

What does A( mean? If your data starts in row 2, does row 1 have headers?

Sorry, it was a type-o ... I meant A

No headers, the information will start in cell A8

Thank you !

 

[mumps]

Does cell A7 have any data in it? Do you want to move or copy A:H?