Copy cells from one sheet to another

[macro_beta]

I'm looking for a macro that can help me copy a row from a sheet to another one. Simple as it might sound, is a little bit more complicated.

I have two sheets one has the raw data and the second one has report format.I will like to run a macro in the sheet looking for cells with a particular customers name and them copy those rows into the second sheet that has fewer columns as it a more easy to follow report.

So in the first sheet i have 12 columns headers and on the second i only have 6.

I'm attaching a sample format, if anyone can help will be great.

I've tried many macros and formulas unfortunately haven't found the solution.

[StephenR]

Couldn't you just use a simple formula, e.g. for Financial Element (in D2)

=Data!L4

etc? Why not just hide columns rather than duplicate your data?

[macro_beta]

Couldn't you just use a simple formula, e.g. for Financial Element (in D2)

=Data!L4

etc? Why not just hide columns rather than duplicate your data?

yes that will be the easy method, but the real raw data file is over 6000 rows and more than 12 customers, i want to divide each customer into one sheet hence the macro.

Is an easier way to report each customer aging time and category which is the objective of the file. the aging time and category are displayed vertically in the raw data but i want to transposed that to be horizontally on the report sheet.

[StephenR]

To remove doubt can you update your attachment because it doesn't seem to tally with your latest statement about one sheet for each customer.

Have you considered pivot tables?

[macro_beta]

To remove doubt can you update your attachment because it doesn't seem to tally with your latest statement about one sheet for each customer.

Have you considered pivot tables?

Updated.

Yes I've tried with pivot, but not a big fan of using pivots as it narrows down the customization ability. For example columns colors etc...

This file will be sent to users that need to view their customer and take action based on aging time.

[StephenR]

I've got some pretty much off the shelf code which could do that. Are the last 6 columns are based on S and U?

[macro_beta]

I've got some pretty much off the shelf code which could do that. Are the last 6 columns are based on S and U?

Yes they are, that was the other problem i found there's 6 category of aging.

0-30
31-60
61-90
90-120
121-360
>360

i have that category shown on the column U and the amount on column S, i want to have those cells shown horizontally instead of vertically. like on the report sheets. is that possible?

[StephenR]

All the age cat entries in your example are "6.>361" which is not obvious. So what are the entries for the other categories? Actually would be helpful if the Col U entries could be labelled same as headings in report sheet. EDIT: a rather more basic question which has only just occurred: what are you proposing to show in each row of the report sheets? A breakdown of by department? Perhaps you could add some sample results to your file.

[macro_beta]

All the age cat entries in your example are "6.>361" which is not obvious. So what are the entries for the other categories? Actually would be helpful if the Col U entries could be labelled same as headings in report sheet. EDIT: a rather more basic question which has only just occurred: what are you proposing to show in each row of the report sheets? A breakdown of by department? Perhaps you could add some sample results to your file.

i changed the label and also put some other entries on col U so you can see the categories.

Yes what i want is that on each sheet to show the customer report (google for example) each row is a PO number showing the amount and category the PO is at. Amount in USD Dollars and the customer name (which is different on each country but is the same google)

i've attached an example on the sheet google showing the end result.

[macro_beta]

anyone has an idea what i could do?

[StephenR]

Are you still looking for a solution to this? Slipped under the radar.

[macro_beta]

Are you still looking for a solution to this? Slipped under the radar.

yes, I'm looking for it, I've tried many different options but haven't had any luck yet.

[snb]

This should do the main part of the trick:

Sub tst()
  With Sheets("Data").UsedRange
     .AutoFilter 3, "*Google*"
     Sheets("Data").Range("A:A,E:E,C:C,L:L,F:F,M:M,U:U").SpecialCells(xlCellTypeVisible).Copy Sheets("Google").Cells(1, 1)
     .AutoFilter
    End With
End Sub

[StephenR]

Another question: will all the entries for any given PO no. fit in the same age category as in your example, or could they be split across several?

EDIT: this would be so much easier if you just used pivot tables!