Combine parts of macros

Hi,

The short answer is Yes.

The trick is to make sure that you break your code down into small generalised procedures which can be called at the appropriate time from any other macros.
Variables can either be passed from the calling code to the sub procedure, or alternatively a Public Variable may be created which will be valid in any of the macro procedures.

Difficult to comment in more detail without seeing the specifics of your system.

I must admit I found your macros somewhat impenetrable and rather too long for easy analysis and reading.

You should aim to keep macro procedures fairly short and concise. Rarely do I find the need to have any procedure more than say 25 lines of code.

That said I question whether your approach is the most efficient. It seems that you are essentially wanting to filter data based on certain criteria. In which case I would use the straightforward Data Filter Advanced Filter.

If you have several different reports, hold the column headers for each one in a separate sheet and when you want to create a report copy the appropriate headers to a common anchor cell.

Create dynamic range names for
"MyData", The Sales Report data,
"DataOut" which is the row of report column headers based on the output anchor cell
"MyCriteria" which is the column headers and selection values.

Above the DataOut header rows have criteria cells for each of your selection criteria and depending on the report add the relevant criteria. Then you can use a simple macro like

Please Login or Register  to view this content.