Search results

Hi Guys, I'm having some problems when I tried to applied a conditional formatting for multiple cells in a row. I have some data for employees that should be updated in some time. I have a column to entry the last time when a record was updated. Then I want to create a conditional...

Hi all, thanks for your recommendations. I will check what its the best for my bussiness case. I think a shared folder will be the most easy and have like a online dashboards should be expensive. Thank you!

Hi All, I have an excel file 2010 with pivot tables and some charts; I wanted to know if someone know any web where can i publish that reports to share with some members of my team. There is any paid or not paid app for this? Thanks

Hi All, I have the follwing code to sort two tables. This code works when its executed in the sheet where the tables are stored. But I want to move this code to another sheet and execute it when that sheet is selected. For some reason i get the folliwing error: "Application-defined or...

Hi All, I work in a small company and we have an excel file to track some changes, after each change we recieved like a receipt but some times this happen days after the change. I have a workbook with all the transactions and one more column "Receipt?" ... In this column are 3 options "Yes"...

Well I'm not removing/clearing the data ... What I'm doing is creating a Spredsheet to manage the stock of a small company.... I'm using dummy data to check its works and to select the correct filters.. What I'm want to do is delete this dummy data and send it to the user to starts to use it...

Hi All, I'm working with a pivot tables and I would like to filter with all the values without a value.. for example HaveTicket <> "No". the problem is I need to setup this filter after have data in the source table; becuase I lose the filter when the pivot table is empty. There is...

Hi bobhc, Ok thanks I will try to what you suggest when the tab was populated by the user. Thanks

Hi bobhc, I uploaed the file that I'm using in the following link: https://dl.dropboxusercontent.com/u/85562478/CONTROL%20STOCK.xlsm There you can find 3 Tabs... "Reporte Stock" is where I have the Pivot tables, two of the three tables get information from the tab "Asignacion Prenda". I...

Hello, I wanted to know if its possible to remove the value (blank) from a Slicer. I get this value because the source of my pivot table is Excel table from (for example) A3:E3 to A2000:E2000. The user will be populated each row with information on differents days,so the empty records that i...

Hi All, I want to get like a summary for a table that i have... they way that I think I can get this information is doing like a dinamic list that show the data "Grouping by [Column1], [Column2], [etc.]" over the table; but i'm not sure its possible. Any idea or other way to achieve this...

Hi All, thanks for the help... really was very helpfull.. I believe i need a combinations of your suggestions...My idea is to create a list with the unique values for "Employee", "Product" and "Size" ... then when this "Keys" use the COUNTIFS to calculate "Assign" - "Unassign" My question is...

Hi SirJB7, What you did is very closed that I need... I attached the spreadhsheet with the data that i have and what i want to report. In the example is like my Primary Keys are "Employee", "Stock Product", "Size", "Actions"... I think I need to group by the keys and calculate +1 when is...

Hi Narayank991 / SirJB7, I wrote this post at night and with the brain borned. Below you can find a sample data with the bussines cases for that . https://dl.dropboxusercontent.com/u/85562478/SampleData.xlsx The table that i building is to track the IN/OUT on a stock; Then this data will...

Hi All, First at all; thanks for help me with this and sorry its my english is not the best :).... I build a spreadsheet to manage a stock. So, when you assign a product (tshirt, jean,ect) to a person, I want to see in a column like +1.. But then if you unassigned this same product to the...