Macro Help

[thegiantrock]

Is there any way to insert data from a filtered data table into a form created on another worksheet with a macro?

In other words, I would like to filter a data table, and then click a button that will transfer only the data on the filtered table to a form on another worksheet.

Thanks

 

[igold]

Hi thegiantrock,

It is fairly easy to copy and paste visible data. Visible data being defined as the data that you see on your sheet after you use a filter.

That being said, I am hung up on what you mean by a form on another worksheet. Is that a userform or just a defined area on a different worksheet. If you could be a drop more explicit or graphic, it may help.

igold

 

[thegiantrock]

Hi igold,

Thanks for getting back to me. It is a defined area on a different worksheet.

So what I would like to do is filter a table on worksheet A that has a name, address, product, and other information, and have that information copied to worksheet B with a macro. Right now when when I run the macro, it takes the cells right under the table headers and copies them to worksheet B, whether the table is filtered or not. So for example, if I filter the table so that row 8 is the only row visible, it still takes the data from row 2 to copy to worksheet B. I would like the row right under the table headers to be copied when filtered.

Thanks, and let me know if you have any other questions.

 

[igold]

It would make it a lot easier if you would like to post your code. I could see where your copying from and where to are going with the data...