Making a Macro to Generate a Report

[joeyjj]

Hello all,

Currently I have a program that consists of several buttons to that the user clicks to input different types of information such as ductwork dimensions and such. What I would like to do after all the information has been input into the worksheet. I would like to make a macro that would copy parts of the information and paste those into a new sheet called Report. Basically I want to summarize the data into a report format, however, I do not need all the data from the worksheet I am copying from. For example if my worksheet looks like this:

Name, Width, Height, Length, Thickness
Duct, 12, 12, 12, 1
Duct, 12, 12, 12, 1



Bad Data, 1, 1, 1, 1


Where each comma represents a new cell. I would like to copy only the information that is Duct, 12, 12, 12, 1 and not the information about and not the Bad Data Below.


Any Advice?

 

[Smitty]

Welcome to the Board!

Have you tried Auto Filter or a Pivot Table?

 

[joeyjj]

Welcome to the Board!

Have you tried Auto Filter or a Pivot Table?

I am currently using VBA and coding to make the report. Would Auto Filter or Pivot Tables be a better option?

The information I have in the worksheet is Noise Attenuation Levels of Ductwork. There are also several blank spaces which I would not like to copy into the report sheet.

 

[Smitty]

I am currently using VBA and coding to make the report. Would Auto Filter or Pivot Tables be a better option?

The information I have in the worksheet is Noise Attenuation Levels of Ductwork. There are also several blank spaces which I would not like to copy into the report sheet.

It all depends on what works for you. Both can remove blank rows if they're set up properly. As much as I like VBA, if you can do something natively, then it's often best to go that route. Although nothing says you can't combine the two...

 

[joeyjj]

It all depends on what works for you. Both can remove blank rows if they're set up properly. As much as I like VBA, if you can do something natively, then it's often best to go that route. Although nothing says you can't combine the two...

Thanks for the advice I will try that out today.