excel & ilogic

I have a lot of data in cells but I am really only interested in certain cells. I want to extract the cell in each row which contains a "-" (there is one in each row) and move them into a column of their own. The entries containing the "-" are not adjacent which makes it tricky to move all of...

Freeze Panes allows you to freeze a portion of cells while you scroll. 1. You can freeze the top row or the left column without doing the following: ____a. Select the Row you would like to freeze the rows above ____b. Select the Column you would like to freeze the columns to the left 2. On...

I have an excel 2013 spreadsheet where I need to load data into sql server 2012 for a onetime load. I am using the data-> workbook connections -> and I am required to select a table from the database that I am pointing to. Thus to me it looks like I need to have a table created in advance on sql...

Hi, I my userform look like this: I have few criteria which to meet. 1. Different customer will have different process and specification 2. If the ID#(textbox1) is empty, the process and the specification will change as well. 3. Different customer will use different G-chip to carry out...

Could somebody help me with this problem: I have a file called PF-Skeleton.xls, this is linked to Inventor to read from and To the excel file. Since few weeks ago, every single time I activate the link via ilogic I have the following error message: A pop up box saying: PF-Skeleton.xls is...