Replies

Inserting suggested code by pasting it into VBA code works just fine. However, trying to type in the change always resulted in a Compile Error.

The good news is that the Macro allows me to automate a process that had been done step by step previously.

Thanks for the assistance.

Inserting suggested code by pasting it into VBA code works just fine. However, trying to type in the change always resulted in a Compile Error.

The good news is that the Macro allows me to automate a process that had been done step by step previously.

Thanks for the assistance.

Your modification does create 26 text files as it should.

I would like for Macro to check for an Entry in first row of column. If it is blank, that is end of data and no more files need be created and Macro should be exited.

Thanks

Your modification does create 26 text files as it should.

I would like for Macro to check for an Entry in first row of column. If it is blank, that is end of data and no more files need be created and Macro should be exited.

Thanks

I seem to have gotten the Macro to Run, but it seems only to create 26 individual files all containing the contents of Column A.

What I need is the contents of each column, which can contain any number of datapoints, to be copied to individual Files. Copying should cease once a blank column or column Z is reached. File
naming seemed to work as I needed.

Thanks for your assistance.

I seem to have gotten the Macro to Run, but it seems only to create 26 individual files all containing the contents of Column A.

What I need is the contents of each column, which can contain any number of datapoints, to be copied to individual Files. Copying should cease once a blank column or column Z is reached. File
naming seemed to work as I needed.

Thanks for your assistance.

Thanks for the information. It was a default setting in Norton SystemWorks.

Thanks for the information. It was a default setting in Norton SystemWorks.

Thanks. That did exactly what I needed.

Thanks. That did exactly what I needed.

Although this routine does allow two axis to show, only one data range is plotted, the one that was chosen with right click. Would like to be able to show both data ranges and their associated axis.

Thanks

Perfect. Does exactly what I needed. Many thanks to all that responded.

Regards,
Thomas

Hans

Thanks for looking at problem. Your observation does allow me to investigate alternatives.

Regards,
Thomas

I have tried the suggested formula, but it does not work as it always selects all dates for Codes, though I don’t see why. See attached spreadsheet which is a sanitized version of the actual one I am attempting to use. Note the difference if one uses an Automated Filter to select dates >=Jun 1, 2002 as compared to using the suggested formula. The automated filter correctly selects 53 entries, the formula selects 72 entries.

SUMPRODUCT(($C$3:$C$90>=$F$2)*($B$3:$B$90=E3)*$A$3:$A$90) is the formula being used. The portion ($C$3:$C$90>=$F$2) is what is bombing.

Any assistance would be appreciated.

Looks as if your answer is in the right format, except, substitute D2 for E2 and it works.

How would formula look if Date is a range rather than just greater than a date.
For example Dates between Jan 13, 2002 and Jun 15, 2003 inclusive?

Thanks for prompt and very helpful reply.

Regards,
Thomas