VBA - Search xls spreadsheet for specific data and move cell value up one position

Hello,

I am very new to VBA programming and have been searching for some time for some examples or solutions to what appears to be an almost unique question about XLS spreadsheets. I am still a bit of a noob, so I do apologize up front.

I have a spreadsheet in which every other row of data in column "C" has a static value of "9999". Within those rows at column "Q" is a variable value in the cell. I am looking to find an external script (not a macro that requires me to open excel in order to run, as I need to be able to run this script from within a batch file in the command line, preferably with the excel window not being shown) in which to find each of these rows, shift the data in column "Q" up by one cell and delete the row containing the static number in order to shorten the excel spreadsheet.

I.E. cell "C2" has the static number of "9999" and cell "Q2" has a variable of "1234". I need to shift the data in cell "Q2" to cell "Q1" and delete the row containing the "9999", but continue parsing the file in the same manner for every other row containing the "9999".

Any help in finding a solution to this scripting issue is greatly appreciated. Links, articles, or even a piece of code or two will help immensely.

Thank you,

Quintin

You can set the Macro to run when it opens.
That way you can open the workbook from the command line then it will run on its own.

You can do this by opening the VBA editor.
On the left hand pane, double click your current workbook, then the Microsoft Excel Objects.
Double click ThisWorkbook.
Then at the top of the script area you will see 2 dropdown menus.
Set the first one to Workbook. The second should set to Open by default.
You can put your code in there.