excel-2010
Chart based on two series and two axis in VB (Excel)
I\'d like to generate a chart in Excel using VB. The chart needs to have two series. One of them should be displayed as values and the other used as x-axis. How can I do that? Additionally, how to set[详细]
2023-03-10 07:46 分类:问答Nesting IF statements in Excel 2010
How do I nest IF statements in Excel 2010? I found my inspiration trying to organize data from Evolus Pencil Support Tickets.[详细]
2023-03-10 00:12 分类:问答TFS 2010 - Import work items using Excel 2010
I have a list of bugs in Excel (exported from an in-h开发者_开发技巧ouse bug tracker). These are in various states - active, deferred, resolved etc.[详细]
2023-03-08 11:16 分类:问答Linking worksheets to a master worksheet and keeping values if the master worksheet is not present? Excel 2010
I have many worksheets and at present, every 3 months I have to go through these one by one to update information in just a few cells.[详细]
2023-03-07 00:17 分类:问答How to link many excel files to one master file, so that if I update the single master file, all linked files also update?
I\'m wondering if anybody can help? I have a large number of excel files. These are commission statements and some are converted from USD to UK Sterling, from UK sterling to Euros etc etc.[详细]
2023-03-06 22:53 分类:问答Macro to copy down text in sections needed
I need an Excel macro to 1.Copy a string 2.Find a different string further down the column 3.Paste the copied string to all the cells in between[详细]
2023-03-05 08:42 分类:问答Wrap rows that have duplicates
I\'ve got data that looks like this: BOB| 4 BOB| 3 BOB| 7 MARY | 1 JOE| 2 JOE| 1 MIKE | 6 I want to end up with data that looks like this:[详细]
2023-03-04 01:37 分类:问答Can I use VBA in Excel 2010 Starter Edition?
I have the MS-Excel 2010 \"Starter Edition\" - it comes bundled into开发者_运维百科 pre-built PCs.[详细]
2023-02-25 00:12 分类:问答Open a web url as an Excel file from inside Excel
I have an Excel file on a website that gets updated regularly. www.mysite.com/Update.xlsx Is ther开发者_开发百科e a way to create a shortcut, or from within Excel to open this link as an Excel docum[详细]
2023-02-24 23:58 分类:问答Extend Formula Range Using Excel Interop
I\'m using the Excel Interop libraries to take 开发者_Python百科a sheet and replace values in the sheet. My sheet structure is as follows:[详细]
2023-02-21 22:29 分类:问答