2010

I want to use the built in user form in 2010 version. My spreadsheet headers go through the alphabet about twice. Does this exceed the limit ? aunfortunately I am not able to build a custom form on this project. Thanks

Hi I have a workbook (let's call it Output.xlsm) that draws in data through external links from another workbook (Source.xlsm). Both of these workbooks are stored in the same folder location. I regularly make a copy the folder so that I can work on new scenarios, while maintaining the...

I have an Excel spreadsheet that reports data that is 18x1 in raw data form, and is stacked side-by-side next to other raw data. Therefore, the amount of data columns that I have stretch out 54 columns. What I would like to do is ultimately have a table that would be 972x1, with each "raw data"...

Hello everyone, I am a first time poster here, but a long time user of Excel. I have not needed to dabble in macros or VBA until recently, so I'm fairly new with them. Using: Excel 2010 Prominent Cell: H4 = Pay Period Ending Date, drop down list of dates through the PPE 12/6/2013 Current...

Hi there, Is it possible to create a macro that when run will show or export pivot table properties in a report? For example, if you right click on a pivot table cell then select 'Show Properties in Report' you can select items indiviudally. This can take a long time if you have a lot of...

Hi there, I've created a spreadsheet that consists of 2 pivot tables that drilldown into 2 individual lists of customer reference numbers based on the individual pivot table report filters. Due to the report filters selected some customer references numbers can be duplicated in either pivot...

Greetings,<o:p></o:p> <o:p> </o:p> I'm exporting data from a Rational database application into an Excel 2010 spreadsheet. I need to parse the data in a way that will group the data by object ID (XX-YY-25xx). <o:p></o:p> <o:p> </o:p> https://www.box.com/s/vgq2hk2bq24ik7jjck9w<o:p></o:p> <o:p>...

Hello, I am trying to create a calculated field in a pivot table (using Excel 2010), whereby the Max of a given field is divided by the Sum for a different field. My dataset includes a history of projects, with multiple expected timeframes for completion. I am retrieving the maximum amount of...

I have a situation that I run into frequently that I am wondering if a macro in PPT could help make the task easier. Routinely, I receive PPTs that contain text and a background image. The person I receive them from puts a text box that covers most of the slide. I drag the text box so that the...

Hi, Despite my limited Excel experience, I am certain Excel has the functionality to generate the tool I need. My current project will require the engagement and management of 50+ contractors. The goal is to create a standard Excel spreadsheet to be provided to each contractor which has a...

Since an upgrade to Excel 2010 from 2003, I seem to be encountering a lot of corrupt spreadsheets. Our IT department can fix them by opening them in Office 2003, saving them as 95 workbooks, then opening the spreadsheets with Excel 2010 and saving as an xlsx document. They won't let us go back...

First off, thanks to everyone for the help you've given me that you don't know about. I've been browsing and finding code that can be altered to meet my needs. So again, thank you. Here's what I have going on: Using Excel 2010 I have a workbook with multiple sheets. Sheet1 is named "UPC" and is...

I use Access 2010, but many clients still have 2003, so I have to deal with 2003-format files all the way. I've developed MyTools.MDB with nothing but macros and modules containing various tools like exporting all objects to text files. I want to make it an add-in so I can open any MDB or...

Hi all, I am creating an Excel add-in in 2010. I'm using the GetVisible & GetEnabled callbacks for a few of my Groups and Button controls. Both functions work flawlessly.... Except when the cursor is in the formula bar or a user types a value into a cell. => In either of these cases, all my...

Hi All- I've searched the web but surprisingly can't come up with an answer for this simple question: Does Access 2010 have a limit on the number of column headers in crosstab queries? If so, what is it? I know that Access 2007 is limited to 255. I need to run multiple crosstabs with ~700...

Hello Forum!! I am in desperate need of some help with a Macro. I have little experience with macros in Access. Basically I have 2 databases one with 922 records and the other with 600 or so records. These databases were just given to me--I am not the original creator. I just need to figure...

Good morning, I have created a form with serveral userforms. Essentially it performs a costing calculation then gives the user the option to log the results in a table on the same page, looking for the next available empty row. Nothing in the code asks to save or close the workbook at any...

hi Please confirm that I cannot filter a merged cell in excel 2010? cheers RM

This question has probably been answered a million times, but.... I am putting a customer sentiment dashboard together that is based on a 5-star rating. 1 not so good and 5 = We Love It. We would like to use a somewhat unique icon set that has 5 stars of which could be colored in partially or...

I have a VBA macro which extracts data and formats it for printing. To the print format I have added a left header containing a text string showing the description of the data, and a left footer which contains a reference number. I have also included in the right footer the current date and...