In excel I have financial data that has "account number" (ex. 1000, 1001, etc) in column 1, "account description" (cash, a/r) in column 2 and the account balance (8,794) in column 3.
Basically I want to know how I can construct an IF statement in VBA that says IF the value in column 1 is greater than 1000 but less than 1005 THEN assign it a value of "cash" in column 4 for all of the account numbers within this range.
Any input would be greatly appreciated!
attached is the project and also how I need the spreadsheet to look like
IDS 331 Project (2).xlsm
http://i.imgur.com/zM1vhE9.png
Bookmarks