Hello, I have a work phone list that I created in excel and have posted on our share drive. What I would like to do is let everyone in the department have...

For a manufacturing report, I currently have each area of production logging work orders into a database. Each of these databases (8 in total) link to three...

Here's a simplified example of what I want to do: Col A Col B Row 1 yes 5 Row 2 10 Row 3 yes ...

I added data to an existing line graph and the data points do not align properly with the values on the Y axis. For example, a data point valued at 119...

Dear experts I have following code which Mike has wroted, i need to change this macro, this code is able to copy several rows (based on values on CoLG) to...

Dear experts I have following code which Mike has wroted, i need to change this macro, this code is able to copy several rows (based on values on CoLG) to...

How do I get the dimension names in the "pivot table field list" sorted by the translated names? The pivot table field list contains: - one measure-node -...

I am creating a 'Parent' Workbook which lists a whole load of documents which are hyperlinked to PDF files of the actual document. I need to create a few...

I have 50 clients, each with an Accounts Recievable worksheet. Past due is determined by using the =now and =today functions. This information is then linked...

Sorry if this is a double post. I don't see my first one. Need help with the if function. If cell K84 says Peds, I need N84 to say Peds. If cell K84 says...

So on one tab I have my colleagues enter certain values for that day and on another tab (a month overview and a year overview) it automatically copies the...

Good day! Is there an easy way to scroll over cells and see the conditional formats without individually going through 'Format' and 'Conditional Formatting'...

Google Adsense Account Approval Tricks New Unique Genuine Google Adsense Account Approval Trick Only For Rs. 1000/-. Take This Trick & Create Unlimited...

Hi, Can you pls. help How to convert excel to HTML and use pivots in HTML? Chris

Hi, Can you pls. help me How to convert excel to HTML and use pivots in HTML? Christ

I have an excel document with a column of hyperlinks. I needed to extract the text of the hyperlink from that column and did successfully using this...

I cant open an excell file - it says read only or encrypted

Hi, I need to make a pivot from multiple sheets. I have tried to make by consolidating the sheets, hoeverthere are some limitations to that. It does not...

I have a database in a workbook which is increasing on a daily basis. the column consiste of e.g Date country T.operators Rm Type Qty Amount etc I have a...