Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring data from header fields to the columns
Hi all,
I need help on automating the following: everyday I get as EXCEL report in the format as described below title1: abc title2: xyz 1 Name1 Id1 Qty1 Cust1 Diff1 2 Name2 Id2 Qty2 Cust2 Diff2 3 Name3 Id3 Qty3 Cust3 Diff3 ... ... title1: pqr title2: def 1 Name4 Id4 Qty4 Cust4 Diff4 2 Name5 Id5 Qty5 Cust5 Diff5 the number of records under each title1 and title2 vary each day. I would like to have the output as below: 1 abc. xyz. Name1 Id1 Qty1 Cust1 Diff1 2 abc. xyz. Name2 Id2 Qty2 Cust2 Diff2 3 abc. xyz. Name3 Id3 Qty3 Cust3 Diff3 4 pqr. def. Name4 Id4 Qty4 Cust4 Diff4 5 pqr. def. Name5 Id5 Qty5 Cust5 Diff5 that is I want the output to be nicely arranged in the columns with the title1 and title2 info also captured in the columns as opposed to as headers. Again the length of the report varies and also the number of records within each title1 & title2. Can someone please help me with a code to automate this task? Thanks a lot in advance for looking into this. Regards, ag |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring data from header fields to the columns
Hi Guys,
I'll really appreciate any help on this. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring data from header fields to the columns
what is the question?
"AG" wrote in message ... Hi Guys, I'll really appreciate any help on this. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring data from header fields to the columns
Hi Patrick,
The question is ... that I want to write a macro to make my data in an excel report from the below: title1: abc title2: xyz 1 Name1 Id1 Qty1 Cust1 Diff1 2 Name2 Id2 Qty2 Cust2 Diff2 3 Name3 Id3 Qty3 Cust3 Diff3 ... ... title1: pqr title2: def 1 Name4 Id4 Qty4 Cust4 Diff4 2 Name5 Id5 Qty5 Cust5 Diff5 To the output format - 1 abc. xyz. Name1 Id1 Qty1 Cust1 Diff1 2 abc. xyz. Name2 Id2 Qty2 Cust2 Diff2 3 abc. xyz. Name3 Id3 Qty3 Cust3 Diff3 4 pqr. def. Name4 Id4 Qty4 Cust4 Diff4 5 pqr. def. Name5 Id5 Qty5 Cust5 Diff5 That is, I need to bring the title1 and title2 values also as one column as opposed to it being in the header. Also, note that the number of records within each title vary on daily reports and also the number of titles appearing on the report also vary. Can you please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print one header over several columns of data | Excel Discussion (Misc queries) | |||
Formula to bring in the header | Excel Worksheet Functions | |||
Bring fields from header to columns | Excel Programming | |||
how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
compare two columns data and bring them to another work sheet | Excel Discussion (Misc queries) |