editing while filtered or combining from multiple sheets?

[jbaich]

Hi all, i'll try to keep this short as i previously wrote a novel here, but timed out before i could post it and now i have to try again

I get an excel report that comes with grouping in place, but with way too much information so i need to delete columns from the grouped tables. In order to do this i need to find a way to edit a filtered table, so that only the selected cells are deleted and the adjacent cells shift left, without affecting any of the non visible cells, rows, etc. Is this possible?

If not, the other alternative is to separate out the grouped data into individual sheets, delete unwanted columns and then try to stitch it back together... The uppermost sheet (customers) has one record per customer, then next sheet (Invoices) could have any number of invoices attributable to each customer and the final sheet (orders) could have any number of items attributed to each invoice. I can use vlookup to find what matches with what, but i lack the VBA skills to write a macro that finds the relevant records and then inserts them below the row to which they correspond in the other sheets... Also, since they will (hopefully) be grouped, each set of records in the sublevels should have it's own column headings as the data in the columns will be different than the main or uppermost column headings... I've attached an abbreviated example that shows a minimalistic view of the data i have and how i'm trying to put it all together. The actual report i start with is huge so i just made up a brief little example, but the jist of it should apply equally well i think.

Any help would be much appreciated. BTW my VBA level is macro recorder + VBA for dummies book = hack simple macros together...

Thanks,
Joe

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.