Search Results

Search found 508 results on 21 pages for 'worksheet'.

Page 1/21 | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• How flexible is the 'indirect' function?

  - by Chuck

  My curiosity pushes me to ask this question. If I were to have a series of functions that referenced a different column in a worksheet but all ended on the same row of data is there a way to point the 'row' part of a cell reference to a blank cell and use it has a variable to show the results of the functions up to a desired row simultaneously? …

  Read the article

• Obtaining Excel worksheet reference by worksheet name via C#

  - by Chapax

  Hi, I'm currently obtaining a handle to a Excel worksheet by using the below C# code: *Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(15);//Get the worksheet "SubSignOff" number* Is there any way that I can obtain the same by using the worksheet name -- "SubSignOff" ? Many thanks for your help. --Chapax

  Read the article

• Create a form as a worksheet in Excel that adds records to another worksheet

  - by Holden Fenner

  I am trying to create a form in Excel for vehicle requests. What I want to happen is to create one worksheet that is a recreation of the current paper form, but have a clickable button that will enter all the data for the vehicle request as a record on a second worksheet. Conversely, if you know the record number, I want the form to auto-flll…

  Read the article

• How to select visibility of specific worksheet at the opening of Excel using Spreadsheet XML

  - by user211607

  Hi, I am getting spreadsheet xml from a code logic (Flex Grids to spreadsheet xml). I have 3 worksheets (A, B, C) in that spreadsheet xml. I am opening this spreadsheet xml in Excel. I want to view worksheet B when I am opening the spreadhseet xml in Excel. Is there any tag/code, I need to add so that worksheet B will be visible at initial?…

  Read the article

• VBA + Polymorphism: Override worksheet functions from 3rd party

  - by phi

  my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure: Fill one cell with a formula, where arguments to the formula specify the query the range of that formula is extended (not an arrray formula!) and cells below/right are filled with data For…

  Read the article

• Copy data from different worksheet to a master worksheet but no duplicates

  - by sam

  hi all, i want to clarify my initial question for a possible solutions from any savior out there. Say i have 3 excel sheets one for each user for data entry located in separate workbooks to avoid excel share workbook problems. I also have a master sheet in another workbook where i want individual data enter on those sheets precisely sheets…

  Read the article

• VBA: How to refer to the right worksheet

  - by stanigator

  Sub Macro1() ' ' Macro1 Macro ' ' Worksheets("Drop-down").Select n = Cells(1, 1).End(xlDown).Row For i = 1 To n ActiveSheet.Cells(i, 2).Select If Worksheets("Misc").Cells(2, i).Value <> "" Then If Worksheets("Misc").Cells(3, i).Value <> "" Then Set validationRange =…

  Read the article

• Excel Worksheet Index

  - by Ben

  I have the following code that works great but I am trying to modify it so that instead of replacing column 1 of the Index page with a new index I would rather start the range in Cell C11. Right now, the new Index starts in Cell A1 of the Index sheet. Here is the code: Private Sub Worksheet_Activate() Dim wSheet As Worksheet Dim l…

  Read the article

• SQL Developer: Why Do You Require Semicolons When Executing SQL in the Worksheet?

  - by thatjeffsmith

  There are many database tools out there that support Oracle database. Oracle SQL Developer just happens to be the one that is produced and shipped by the same folks that bring you the database product. Several other 3rd party tools out there allow you to have a collection of SQL statements in their editor and execute them without…

  Read the article

• MS Excel - Copying columns from multiple worksheets into a single worksheet based on some condition

  - by SpikETidE

  Hi everyone... Consider i have 4 workbooks with the following structure... 1. Main.xlsx Name Jan Feb Mar A B C 2. Jan.xlsx Name Jan A 3.3 B 6.4 C 5.3 3. Feb.xlsx Name Feb A 1.3 B 3.4 C 5.5 4.…

  Read the article

• How do I find out what's linked to my Excel Worksheet?

  - by dwwilson66

  I've got an Excel 2007 worksheet that I inherited, and each time it opens, I get the dialog box asking if I would like to update values from an outside, linked worksheet. I'm trying to track down if I should be saying yes or no; as I'm not familiar with the linked spreadsheet, nor what types of data it creates, nor if it's even…

  Read the article

• Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

  - by hornetbzz

  I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to dynamically update all worksheets upon any of a single or several changes on the data source worksheet. I may understand this should…

  Read the article

• How to include worksheet 3 and 4 in a cell formula provided?

  - by user21255

  I have been kindly given this formula with an explanation on how it works: Insert this formula into the cell B4 of the sheet "Cases": =IF(NOT(ISBLANK('1st'!B25)),'1st'!B25,IF(NOT(ISBLANK(INDIRECT("'2nd'!R" & (ROW($B4)-(COUNTA('1st'!$B:$B)-COUNTA('1st'!$B$1:$B$24))-4+25) & "C" &…

  Read the article

• Make Excel Defined Names within a worksheet to be global

  - by idazuwaika

  Hi, I wrote Powershell script to copy a worksheet from a workbook A to another workbook B. The worksheet contains define names for ranges within that sheet. Originally, the defined names are global in workbook A, ie. can be referenced from any worksheets within workbook A. But now, after…

  Read the article

• Excel: Conditional Formatting (Highlighting) Values Based on Another Worksheet

  - by ScottSEA

  I have a workbook that has two worksheets. The first worksheet is simply a list of the first 78,498 prime numbers in a single column, A1-A78498. The second worksheet has a grid of numbers from 1 to n. The goal is to highlight the cells with prime numbers in the grid by referencing the…

  Read the article

• Running & Managing Concurrent Queries in SQL Developer

  - by thatjeffsmith

  We’ve all been there – you’ve managed to write a query that takes longer than a few seconds to execute. Tuning aside, sometimes it takes longer than you want for a query to run. So what’s a SQL Developer user to do? I say, keep going! While you’re waiting for your query to finish,…

  Read the article

• Allow paste in worksheet without overwriting locked cells

  - by jjeaton

  I have a protected worksheet that users would like to copy and paste into. I have no control over the workbook they are copying from. The protected worksheet has some rows that are available for data entry, and other rows that are locked and greyed out to the user. The users…

  Read the article

• OpenXML sdk Modify a sheet in my Excel document

  - by user465202

  hi! I create an empty template in excel. I would like to open the template and edit the document but I do not know how to change the existing sheet. That's the code: using (SpreadsheetDocument xl = SpreadsheetDocument.Open(filename, true)) { WorkbookPart wbp =…

  Read the article

• Excel 2007 - Worksheet is larger than the window

  - by Chris

  Hi This is an odd problem but frustrating none the less. I have a worksheet saved which is larger than the Excel 2007 "workarea". This means when I open the worksheet I cannot access the corners of the worksheet to reduce the size and the worksheets title bar area…

  Read the article

• Excel 2003 Freezes When Worksheet with PivotTable Selected

  - by Max

  All of the sudden, my Excel 2003 began an odd behavior today. Whenever I click on a worksheet tab that has a PivotTable on it, I become unable to click on any other tabs or on the menu with the options to minimize, maximize, and size at the top left of the worksheet…

  Read the article

• What is the best template of a Developer worksheet ?

  - by The Knight

  Hello there, I've a kinda managerial question, what is the best template or format of a developer worksheet that illustrates the task Name, description, date, and running time !! and helps me to get total time/date easily. if there is any software tool that handles…

  Read the article

• Excel 2007 How To Reference A Seperate Cell In WS1 From A Common Cell In WS2

  - by Bob Sampson

  I have a simple file with two worksheets in. In the first worksheet (a product list) are a number of columns, including Product Code and Product Description. In the second worksheet (dispatches in January), I have Product Code. I need to insert a new column with the…

  Read the article

• SharePoint Planning/Design Worksheet Links

  - by Mike Huguet

  I ran across a blog entry with a consolidated list of links to the SharePoint 2007 planning worksheets.  These are good starting points for your discovery, analysis, and design and are provided by Microsoft.  I would suggest tweaking them to meet your…

  Read the article

• Excel Automation From .NET - creating a new worksheet

  - by Andrew Shepherd

  I am attempting what seems like a simple task: using C# to create a new Excel document containing new worksheets. For some reason, I am getting a strange COM error (0x800A03EC) Has anyone managed to get this to work? Does anyone have suggestions as to how to…

  Read the article

• Excel Automation - creating a new worksheet

  - by Andrew Shepherd

  I am attempting what seems like a simple task: using C# to create a new Excel document containing new worksheets. For some reason, I am getting a strange COM error (0x800A03EC) Has anyone managed to get this to work? Does anyone have suggestions as to how to…

  Read the article

1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >