Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

hi Sudhir, pls find code below- Sub test() Sheets("Output").UsedRange.Clear Dim i As Long Dim j As Long Dim k As Long Dim s As Long k = 2 Sheets("Input").Select For i = 2 To Range("a4").Row For j = Range("e5").Column To Range("g5").Column For s = Range("i5").Column To Range("k5").Col

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

can u please resent me complete code. On 6 February 2014 12:55, ashish koul wrote: > you need to add if condition here > > if Cells(i, s).value <> 0 then > Sheets("Output").Range("g" & k) = Cells(i, s).text > end if > > > > > On Mon, Feb 3, 2014 at 6:28 PM, Umesh Kumar wrote: > >> Hi Ashish, >

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

you need to add if condition here if Cells(i, s).value <> 0 then Sheets("Output").Range("g" & k) = Cells(i, s).text end if On Mon, Feb 3, 2014 at 6:28 PM, Umesh Kumar wrote: > Hi Ashish, > Thanks a lot for the code, it worked well. It saved lot of my time. > > One question, do you know how t

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

Hi Ashish, Thanks a lot for the code, it worked well. It saved lot of my time. One question, do you know how to add a condition that if the % is given as zero, then we can ignore that particular cell. I have given an example in my initial question. The reason I am requesting for including this

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

Sub test() Sheets("Output").UsedRange.Clear Dim i As Long Dim j As Long Dim k As Long Dim s As Long k = 2 Sheets("Input").Select For i = 2 To Range("a4").Row For j = Range("e5").Column To Range("g5").Column For s = Range("i5").Column To Range("k5").Column Range("a" & i & "

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

Hi, My apologies, i uploaded the wrong work book second time around. Attached is the actual book.* (File Name: Request.xlsx)* On Tuesday, 28 January 2014 00:26:27 UTC+5:30, bé trần văn wrote: > > You see File, with PivotTable VBA. > > 2014-01-27 Umesh Kumar > > >> Hi Ashish, >> I had pasted the

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

Hi Ashish, I had pasted the sample file. Will attache it again. On Saturday, 25 January 2014 12:52:29 UTC+5:30, ashish wrote: > > please share sample file > > > On Fri, Jan 24, 2014 at 2:13 PM, Umesh Kumar > > wrote: > >> I would need help in converting table which is in table format to a pivot

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

please share sample file On Fri, Jan 24, 2014 at 2:13 PM, Umesh Kumar wrote: > I would need help in converting table which is in table format to a pivot > format. Below is the sample data which i have: > > >

$$Excel-Macros$$ Need help in converting table format data to pivot format in excel

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have: