Selective Cut and Paste VBA and Variable Length Sum

[brad7989]

Thanks for coming to this thread - I appreciate it.

I have been working on a macro to automatically prepare a report from some data that is almost in the correct format. I have two issues that are holding me back from finishing the macro (and saving a lot of time).

1) I would like my macro to cut and paste entire rows (different amounts of these rows depending on the data file) from the body to below a created summary chart at the bottom. I need to have it search for a specific key word in a particular column that may have something in front of it. My macro will then need to select the entire row. If you know how to do this for data with variable amounts of these rows, I'd appreciate it.

2) I need the created summary row to sum entire columns from row 6 to just above the summary row. I have struggled to get this to work for variable length data-sets I import. If you know how to do this, I'd appreciate your help.

Thanks!

 

[brad7989]

Also, if someone knows how to pull data into excel when it comes from a pop-up of a website. I've tried pulling data from the internet from the ribbon button, but the excel browser doesn't open the popup - it goes to internet explorer.

Thanks!

 

[brad7989]

bump

 

[RSXchin]

Can we see a sample of your data? How do you know which rows to cut? and how do you know where to paste them?