Using variables in formulas/ranges

[lfmaykot]

Note: I am pretty new to this, so forgive my mistakes.

I have a worksheet that changes every month. New rows are added or subtracted, so I need to use variables to select ranges.

I have been trying to use variables to select a certain range in another worksheet so I can use it in another worksheet. The code is below. I am getting errors at these two spots:

Please Login or Register  to view this content.

Any help is appreciated.

Please Login or Register  to view this content.

[scott.s.fower]

aren't you going to want this to be dynamic so you can make it work for jan, feb...dec? or do you only want to sum net incom (loss) for january?

it is best to post a sample workbook, but take out any sensitive info and replace it with dummy data, hit the go advanced button and click the paperclip to attach a file

try something like the following which asks the user to input the month to be summed with an input box, then uses the search function to search for the appropriate month and sums the Net Income (Loss)

here's a copy of the workbook with the macro and a form button to run it NIL example.xlsm