PLS FIND ANOTHER TOPIC AND HELP ME

"HELP!! ARRANGE MULTIPLE ROWS IN A SINGLE ROW "

YOurs
sajay


On Nov 20, 4:31 pm, "Roger Govier"
wrote:
Hi

Of course the problem can be solved writing code with VBA if that is
what you want to do.
In my opinion, the Pivot Table approach provides the easiest solution.

Another alternative, would be to set up a Master sheet with your
Headings starting in A2 and going down column A.
In B1 through M1 enter the Months Apr, May etc.

Each month, copy your data to a new sheet within the Workbook, and
rename it to the relevant Month Name.

In cell B2 of the Master sheet enter
IF(A2="","",
IF(ISERROR(VLOOKUP(A2,INDIRECT("'"&B$1&"'!A:B"),2, 0)),"",
VLOOKUP(A2,INDIRECT("'"&B$1&"'!A:B"),2,0)))

Copy across through C2:M2
Copy B2:M2 down for as many rows as you have headings in your Master
sheet.

--
Regards

Roger Govier

"sajay" wrote in ooglegroups.com...





dear roger and sandy man

both of you are referring to Pivot tables.
well I will certainly try it
but don't there have any other options??
what i did was as decribed earlier
and put a formula in the D column

IF(EXACT(A2,A3), C3, "") \\=if(exact(cell1, cell2), cell2's amount,
blank)
and deleted the duplicate cells by putting another formula in E column
IF(EXACT(A2,A3), "$$", "")
and sorting with that cell
but every month doing the same things is quite borring
so i thougt there will be some easy ways (as the methods are same for
all months)
i do believe that VBA can do a long way.

YOurs,
sajay- Hide quoted text -- Show quoted text -