Search results

I don't want my users to be able to select multiple items in a pivot table. Does anyone know of a simple way to disable this option in the pivot filter/slicer? Thanks!

I'm having some performance issues with a workbook I created. There are some significant data tables (the largest is 38,000 records), and I use a lot of Index functions. I'm having performance problems (the spreadsheet stops to process every few minutes, and it can take up to a minute to...

I have a very large data set (38,000 rows), and I have a lot of columns using lookups from reference tables on other sheets. I'm currently using Index. When I do anything in the workbook, it takes about 5 seconds for it to process. I'm wondering if Vlookup is quicker. Or is there another lookup...

I have a very large data set (38,000 rows). I've created a sample spreadsheet (attached) that is much smaller, but that illustrates what I want to do. Table 1 is my data set. Table 2 is a table that contains a list of words that I want to use to search Table 1 with. I'd like a function for the...

I have a product inventory database in Excel. Each item in the inventory has a URL that contains a picture of the product. I'd like to find a way to automatically "grab" the picture and insert it into the spreadsheet so that each product in the inventory contains a picture. Here is an example of...

I have a spreadsheet that uses the WORKDAY formula, referencing a named range HOLIDAYS on a separate sheet. When I added that formula to my spreadsheet suddenly everything slowed down (the formula is in about 20 cells). There is a half-second delay after I do anything in the spreadsheet (which...

I have a block of cells that each have the same equation in them that inserts into the cell a symbol or text based on a formula. I then conditionally format the block based on the symbol within each cell. The columns are very narrow in the block, and longer text gets truncated by the cell next...

I'm using the Workday function in a workplan spreadsheet to calculate the due date of tasks given the start date, the number of days required for the task, and holidays. This assumes a 5-day work week. I'd like to also calculate due dates based on a 6- and 7-day workweek. I found the...

I have a sheet in a workbook with 15 conditional formatting rules. When I copy the sheet within the same workbook, the copied sheet only has all of the rules, but they'be been re-ordered. Thoughts on how to fix this? Thanks, David

I have a pie chart that references a set of data. I would like each wedge in the chart to automatically take on the color of the cell that it pulls from. E.g. If my data series is 1,4,3,5,8, and each wedge corresponds to one of those numbers, if the cell with "3" in it is green, I want the...

I'm using named ranges within my workbook. One of my sheets (Sheet 1) has about 5 named ranges. Other sheets in my workbook refer to those ranges. But when I copy sheets that have nothing to do with the named ranges (e.g. sheets that do not refer to the ranges), I get a bunch of messages that...

I am creating an invoicing function in a table of sales (SalesTable). The code currently allows me to select multiple rows in SalesTable and then it takes the data from those rows (each row representing a line item sale) and creates an invoice. The code creates an invoice number. I'd like to be...

I would like to create a macro that copies a row of data on one sheet and appends it to the bottom of a table on another sheet. The only way I can figure out how to do it is to insert the copied row above the first row of data in the table (because I know that will always be row 2 of the...

I'd like to create VBA that will look to see which cells are active and then select all of the rows for those cells. E.g. On Sheet 1 I select cells A1, B1, C1. I'd like the macro to then select rows A, B, and C.

I'd like to do the following: I'm trying to create a tool to assign staff to various roles in an ongoing project. Each staff member has data associated with him/her (e.g. skills, years experience) that need to be taken into account when an assignment is made. Sheet 1 is where I want to enter the...

Help! I'm creating a template for a calendar, and I want to conditionally format the number cells so that if there's a holiday (e.g. text) in the cell below it, it will turn red. So, for example, I'd like the "1" for New Year's Day to be red because there's text in the cell below it. See the...