excel 2012

I have a query that does the following: Drops Table #Temp if it exists Creates a new temporary table called #Temp (which I have in other queries that work) Declares some variables Sets a loop-count variable (by counting the rows of the Table Schema). WHILE the @NumberofLoops <= my loop count...

Hello! I'm completely new to this forum and my knowledge in excel is scarce. Searching for similar posts is hard and that's why I decided to make a new post. So. I'm using Excel 2012 and have a large excel file. This file contains these kind of worksheets: data of items (each worksheet...

Hello all, I have a macro I am working (see below). I have defined "varCellvalue" as a name of a Excel file in a cell which is a drop down list and "VarCell" as a Sheet name in every file of the drop down list so what I am trying to accomplish is that whatever a user selects as a file and a...

I have a PivotTable and beside it I have added a Comment column beside the PivotTable (outside the pivot and aligned with each row in the pivot), which is a free text column and not connected to the data source of the PivotTable. When sorting, filtering or refreshing the PivotTable the Comment...

Hi all, I am using Excel 2010 and still getting used to the flaky parts. I'm working with a spreadsheet was originally a Notebook document. Successfully opened the Notebook file in Excel and saved it as an Excel 2010 spreadsheet, and am attempting to sort and manipulate data, removing dupes...

Hello all I need help with a funky lookup In Column A & B Cell A2 - Aegis IT LTD Cell B2 - Aegis LTD INC. I need a vlookup that will look in column A and see the "Aegis IT LTD" and then look in column B and because the "AEGIS LTD INC." is pretty darn close to correct return that as my...

Hello all, I need help with a formula that looks in row A and finds the last cell with data and returns the cell number once found. Thanks for your help!