$$Excel-Macros$$ Re: xml download "argument not optional"

Got the solution Pool needed to be Poola or anything different than Pool as it is already being used Ta, Martin On Friday, January 10, 2014 1:41:26 PM UTC+13, Martin Wheeler wrote: > > I am trying to convert some code from single sheet to multi-sheet so I can > use in an existing excel workbook

$$Excel-Macros$$ Hi Group

Hi , i am new on this group, would like to be good in excel and VBA, i would need your help. Thanks manish. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FO

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Hi Tom, Please manually enter the "Cusum" tab, showing the desired result. As for the "H" column want the macro to copy the data in this column? Tks. Basole Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Experts, > > I am looking to copy i

$$Excel-Macros$$ xml download "argument not optional"

I am trying to convert some code from single sheet to multi-sheet so I can use in an existing excel workbook - up to 70 wk sheets It is in Public Sub LoadRaceField(wks As Worksheet) If accepts:- Set runnerList = xmldoc.SelectNodes("//Runner") For I = 0 To (runnerList.Length - 1)

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Basole, That's incredible, how do you do that?! Macro to do this, I inserted a function that reverses the data of the cell then the code puts the data in ascending order, and then inverts the data again. tks. Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley esc

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Hi Tom, yes that what you want is possible. To do that I need additional information, such as name of the workbook, description of the column and rows etc.. Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Experts, > > I am looking to

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Basole, That's incredible, how do you do that?! is there any way to do it which the whole row and copy the rows into a different sheet? Thanks for all your help Tom On Thursday, January 9, 2014 12:33:45 PM UTC, Basole wrote: > Dear Tom, here me the macro is working perfectly. I am attaching a

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Dear Tom, here me the macro is working perfectly. I am attaching a workbook for you to test. Basole. Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley escreveu: > > > > Hi All Experts, > > I am looking to copy individual rows of data from one spreadsheet > which are sepa

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Hi Basole, The first step worked but the other two both had errors and I couldn't run them. is there anything you can suggest? Thanks Tom On Wednesday, January 8, 2014 3:41:14 PM UTC, Basole wrote: > 'Hi Tom Yaxley, > > 'try this macro, copy and paste the code in sheet1 and to test, put some

$$Excel-Macros$$ Re: help!!! creation code from data in cells

In an excel file, Change Sheet1 Name as Report and type these: Sr. Center Name Course Date of Enrol Code 1 Alma Computer Training Institute Suraj basic computer Course 31/12/13 2 Center3 Name1 Course 5 1/1/2014 3 Center5 Name2 Course 3 1/4/2014 4 Center2 Name3 Course 4 1/6/2014 5 Center4 Name4