tagged [worksheet]

Use string value from a cell to access worksheet of same name

Use string value from a cell to access worksheet of same name I have 2 worksheets: `Summary` and `SERVER-ONE`. In cell `A5` on the Summary worksheet, I have added the value `SERVER-ONE`. Next to it, i...

10 Apr at 07:4

C#: Getting the number of rows/columns with ExcelPackage

C#: Getting the number of rows/columns with ExcelPackage I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using E...

C# - How to add an Excel Worksheet programmatically - Office XP / 2003

C# - How to add an Excel Worksheet programmatically - Office XP / 2003 I am just starting to fiddle with Excel via C# to be able to automate the creation, and addition to an Excel file. I can open the...

22 Aug at 13:47

How to import data from one sheet to another

How to import data from one sheet to another I have two different work sheets in excel with the same headings in in all the row 1 cells(a1 = id, b1 = name, c1 = price). My question is, is there a way ...

25 Apr at 17:39

Get values from other sheet using VBA

Get values from other sheet using VBA I want to get values from other sheets. I have some values in Excel (sheet2) for example: I sum each column in row 4. I'm working with these values in sheet2 but ...

17 Jul at 13:52

I want to compare two lists in different worksheets in Excel to locate any duplicates

I want to compare two lists in different worksheets in Excel to locate any duplicates I know this is very simple but I still need help: I have a list of properties that have finished a training. I nee...

15 Nov at 05:27

How to write a step function using IF functions

How to write a step function using IF functions I have 3 ranges of numbers and the answer depends on the range. I tried to create an equation that accounts for the ranges by using nested `IF` function...

String manipulation with Excel - how to remove part of a string if another part is there?

String manipulation with Excel - how to remove part of a string if another part is there? I've done some Googling, and can't find anything, though maybe I'm just looking in the wrong places. I'm also ...

4 Nov at 21:20

Excel tab sheet names vs. Visual Basic sheet names

Excel tab sheet names vs. Visual Basic sheet names It seems that Visual Basic can not reference sheets according to user-modified sheet names. The worksheet tabs can have their names changed, but it s...

24 Nov at 23:35

Is there a macro to conditionally copy rows to another worksheet?

Is there a macro to conditionally copy rows to another worksheet? Is there a macro or a way to conditionally copy rows from one worksheet to another in Excel 2003? I'm pulling a list of data from Shar...

9 Jul at 18:41