Reduce code recorded from a macro in excel vba using a loop

Hi All,

I a newbie VBA coder but finding it really difficult to reduce my code from a recorded macro using a loop - i'm pretty sure i need a loop as i was copying and pasting data from one data table into a newly created summary table. Could anyone help me please? Any help would be much appreciated!

The code is too long to add into the post so i've attached a notepad file ...

Hi
can you tell us what you want the macro to do? That would be a lot easier than scrolling through the code

Hi,

I want to be able to create a new table (with no formal table headers), with 8 customer names going down the first column and then the top row will be cell titles that i have copied from another table in the same worksheet. Then for each of the customers in the table i would copy/paste the data from their respective tables in the worksheet into the correct column header but in the form of an icon and not a data value.

TableExample.png


The data in column 1/2 has been copied and pasted from another table in the same worksheet.

I hope that makes better sense now

Thanks for your help

ok, without seeing your spreadsheet it's a bit hard to work out, but this should give you some ideas

it copies your headers from one range, matches names in a second range with a larger source table containing these and other names,
then copies these values into the columns next yto your names list. Then, it searches and replaces values in that area of the worksheet.

Please Login or Register  to view this content.

I've attached my spreadsheet - hopefully this will show what i'm trying to do ... I've not completed the copy/paste action in the macro as the code was getting too long

Thank you for your help