Hello,
I'm working on a project and wanted to see if someone could help me, either by using VBA or another way.
I'll have data in a worksheet name "Data" in Column C.
Lets say column C contains the following:
Row 1 = Bank of America
Row 2 = Company Deposit - John Doe Company
Row 3 = Denny's
I want excel to be able to do the following for me in Column A of the "Data" worksheet:
(#1) If cell in column C is blank, skip this row and go to the next row.
(#2) If cell in Column C contains (have it search through all search criteria on another worksheet named "Search Criteria), then put in this cell what is listed in column B of the "Search Criteria" worksheet.
(#3) If excel can't find any matching criteria on the "Search Criteria" worksheet, then enter the word "Manual" into the cell.
Note: I don't want it looking for an exact match. So if cell C said, "Bank of America", and I had "America" listed on the "Search Criteria" tab, I'd want it to pull over the data.
So lets say I'll have another worksheet called "Search Criteria" with the following criteria and results:
|Col A|--------------|Col B|
|America|------------|1000|
|Wal-Mart|-----------|2000|
|Company Deposit|---| 3000|
1) So I'll push a button, excel will go down each row in column A of the "data" worksheet...
2) if the cell in column C of that row is blank it'll just go to the next row...
3) if there is data in column C of that row, it will search column A on the "Search Criteria" worksheet and if it finds the criteria, it will take the result of column B of that worksheet and pop that into the cell of the "Data" worksheet...
4) if it doesn't find any matching data in the search criteria, I want it to put the word "Manual" into the cell on the "data" worksheet.
The end result will be on the "Data" worksheet:
|Col A|---|Col B|--|Col C|
|1000|----||-------- |Bank of America|
|3000|----||-------- |Company Deposit - John Doe Company|
|Manual|--||--------|Denny's|
Is something like this possible?
I'm using excel 2007.
Thank you for your help!
I'm working on a project and wanted to see if someone could help me, either by using VBA or another way.
I'll have data in a worksheet name "Data" in Column C.
Lets say column C contains the following:
Row 1 = Bank of America
Row 2 = Company Deposit - John Doe Company
Row 3 = Denny's
I want excel to be able to do the following for me in Column A of the "Data" worksheet:
(#1) If cell in column C is blank, skip this row and go to the next row.
(#2) If cell in Column C contains (have it search through all search criteria on another worksheet named "Search Criteria), then put in this cell what is listed in column B of the "Search Criteria" worksheet.
(#3) If excel can't find any matching criteria on the "Search Criteria" worksheet, then enter the word "Manual" into the cell.
Note: I don't want it looking for an exact match. So if cell C said, "Bank of America", and I had "America" listed on the "Search Criteria" tab, I'd want it to pull over the data.
So lets say I'll have another worksheet called "Search Criteria" with the following criteria and results:
|Col A|--------------|Col B|
|America|------------|1000|
|Wal-Mart|-----------|2000|
|Company Deposit|---| 3000|
1) So I'll push a button, excel will go down each row in column A of the "data" worksheet...
2) if the cell in column C of that row is blank it'll just go to the next row...
3) if there is data in column C of that row, it will search column A on the "Search Criteria" worksheet and if it finds the criteria, it will take the result of column B of that worksheet and pop that into the cell of the "Data" worksheet...
4) if it doesn't find any matching data in the search criteria, I want it to put the word "Manual" into the cell on the "data" worksheet.
The end result will be on the "Data" worksheet:
|Col A|---|Col B|--|Col C|
|1000|----||-------- |Bank of America|
|3000|----||-------- |Company Deposit - John Doe Company|
|Manual|--||--------|Denny's|
Is something like this possible?
I'm using excel 2007.
Thank you for your help!