$$Excel-Macros$$ Re: Turning 2 columns into a table

The attached Workbook contains a macro (ColToTable) that does what you describe. It's not elegant but appears to work. If you have any questions let me know. Tom On Wed, Nov 19, 2008 at 12:43 PM, KO <[EMAIL PROTECTED]> wrote: > > Hey all- > > I have been searching every Excel help site I can fi

$$Excel-Macros$$ Excel VBA Vlookup row and column variables

I am trying to do a vlookup on my Excel spreadsheet using the following VBA code: Dim row As Integer Dim prodCodeCol As String Dim weightCol As String row = 2 prodCodeCol = "O" weightCol = "J" Range(weightCol & row).Select ActiveCell.FormulaR1C1 = "=VLOOKUP(" & prodCodeCol & row & ",'[Kogan WMS

$$Excel-Macros$$ Re: Drop down / combo list in a cell

Go to Data -> Validation - > and select validation criteria as allow list... _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things

$$Excel-Macros$$ Re: Drop down / combo list in a cell

The Excel Validation feature will do what you want: 1. Select the cell(s) you want to validate. 2. On the Data menu click Validation then click the Settings tab 3. In the Allow box select List 4. Select Range containing allowed values 5. Click OK The attached spreadsheet illustrat

$$Excel-Macros$$ Re: Drop down / combo list in a cell

Hello, Naveen. Thank you very much for the clue. It was there, but I didn't know it. Anyway, if the cells are modified after being used as a selection to build the list, the "drop down list" in the target cell is also modified. Is there any way to "fix" the list in the target cell? Thanks. --

$$Excel-Macros$$ Re: devide column values into two columns

Dear Group Members, I wanted to create a line chart, but to set its X axes in a nonstandard way. To do that I inserted some empty cell between data. I got what I wanted. But this time line itself disappeared. Now I have data points only... Line is not shown. I don't know whether macros have someth

$$Excel-Macros$$ Re: devide column values into two columns

Hi there, You can seperate this data by using convert text to column wizard-> choose option "delimited"-> then choose "next " -> the select delimiters "comma" ->then choose column data format "General" then "finish". You will get this data AAA Inc. Series1 ABCD Ltd. Class 99 1234 Bank Some

$$Excel-Macros$$ Re: devide column values into two columns

Dear all I am using Vista with Office 2007. I am getting error message When I save or save as any documentI am getting the following message: "Your changes could not be saved to XXX because of a sharing violation. Excel

$$Excel-Macros$$ Re: Move all data to one column

You can use the following macro. Note: This macro will move all the data to column-A. ' Sub moveTo1Col() Dim i As Integer, j As Integer i = 2 While Cells(1, i) <> "" Cells(1, i).Select Range(Selection, Selection.End(xlDown)).Se

$$Excel-Macros$$ Re: devide column values into two columns

One way to do this is use the following function. '- Function splitText(r As Range, s As String, col As Byte) Dim txt As String Dim c txt = r.Value c = Split(txt, s) splitText = c(col - 1) End Function '-

$$Excel-Macros$$ Sub not visible

I have a sub procedure written under another procedure. When I press F5 to run the procedure, it is not listed in the drop down menu but the code right above it is. Any suggestions? Thanks. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http:/

$$Excel-Macros$$ Re: Move all data to one column

you can moved data in a single coloumn thourh the excel function "Concatinate" Use this one. Regards. On 11/19/08, TerryP <[EMAIL PROTECTED]> wrote: > > > I have data in multiple columns like this : > http://spreadsheets.google.com/pub?key=pD3DJDAymrEspkRfQWMOTUg > > I'd like data moved to one s

$$Excel-Macros$$ Re: devide column values into two columns

The attached Workbook contains a macro(SplitCol) that does what you describe. If you have any questions let me know. Tom On Wed, Nov 19, 2008 at 10:13 AM, Mike <[EMAIL PROTECTED]> wrote: > > Hi, > i have a data populated into a column with company name and other data > devided by a comma. > > So

$$Excel-Macros$$ Re: Move all data to one column

Dear u can use the formula concatenate Eg. =concatenate(c1,c2,c3...c50) and then enter On Wed, Nov 19, 2008 at 10:06 PM, TerryP <[EMAIL PROTECTED]> wrote: > > I have data in multiple columns like this : > http://spreadsheets.google.com/pub?key=pD3DJDAymrEspkRfQWMOTUg > > I'd like data mo

$$Excel-Macros$$ Re: Single pivot for more than one sheets

In office 2007 I count get the option like the same .,..how it can be done On Wed, Nov 19, 2008 at 6:26 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote: > What specifically doesn't work? > Tom > > > On Wed, Nov 19, 2008 at 2:33 AM, arun p <[EMAIL PROTECTED]> wrote: > >> Tom, your combineworkshe

$$Excel-Macros$$ excel with SQL

Hi I was not sure where to go and was wondering if anyone could help me out. I am trying to generate charts in excel via queries against a database. I've managed to connect excel to the database. I've also created a procedure within the database. However I don't know how to excecute the proc wi

$$Excel-Macros$$ Re: Drop down / combo list in a cell

Hi,   Yes it can be done using Data validation in DATA menu-->List-select source.   wil be helpful for u...  Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Wed, 11/19/08, Vicent Giner <[EMAIL PROTEC

$$Excel-Macros$$ Re: devide column values into two columns

Look at Text-to-Columns It's on the data tab in Excel2007. I don't remember where it is in 2003 or office97 but that's what you're looking for. Paul - Original Message > From: Mike <[EMAIL PROTECTED]> > To: MS Excel & VBA Macros > Sent: Wednesday, November 19, 2008 10:13:32 AM > Subj