report

Hey guys, Can anyone help me out with this? I'm creating an expense report, and using rows 10-19. In column K is a spot for "Other" (unspecified expenses) there could be costs located in there, say K11, K13, K14,K18. What I want to know is how can I automatically list any costs in that column...

Hi Folks, I have Master data and the date field is in the format "DD-MMM-YY" and from this Master data i have generated a Pivot report with several other fields and after generating report the date format i see as only MMM but not " DD-MMM-YY"format like what my source data has. I tried format...

My slicers are using different tabs for sources, so they won't link in the report connection. I once created a massive slicer that would edit any slicers you attached to it without using the report connection feature. Although, for the life of me, I cannot remember how I did this. Any...

Good day, I have been working to simplify a log that is used by a lot of people I work with. I originally built it years ago with helper columns and need to get rid of them. I have 2 items I need to solve but will post the second one in a different post. Item 1: I have a massive log, column B...

Hi, I cannot think how to do a horizontal search to find a Section Number (Cabin 15001) and hope you are able to help me? The stats screenshot, I would like to be able to add the Section number for 15001, but cannot for the life of me work out how to do it for all cabins for each section...

Good afternoon, Excel gods. I got another question. I have a little under 700 items that I receive bi-weekly price changes. I have set it up as pictured. Is there any way to print a flash report showing only price changes? Like shown in the second image. Thank you so much for your assistance.

I need to produce a SKU GAP Fill report and would like to get some help. We have thousands of accounts and 53 SKU's and I need to find out from the sales reports from distributors which accounts are missing key SKU's. Any help would be appreciated.

Hi Very Urgent and very necessary. Please someone reply Kindly some one please help me to make month wise and customer wise report from a unsorted data with Pivot Table or Macro. sample file link attached here https://www.dropbox.com/s/cdl5r9k24f6banb/Sample.xlsx?dl=0 :confused:

Hi please someone help me to make a sales report as per the attached sheet as in the Sheet2 . If someone help me I will be very thankful. https://www.dropbox.com/s/6lcxtojqs8s977x/Dummy.xlsx?dl=0

Hi Can someone kindly help me to make a customer wise and month sales report with the file attached. Can we make with pivot table. https://www.dropbox.com/s/cdl5r9k24f6banb/Sample.xlsx?dl=0

This isn't an "how do I do something" post (yet), but an "is it possible" post. I don't want to invest a lot of time and effort into trying to create something if it isn't possible, so I haven't even started creating a database yet. My background with MS Access is as a user, not a creator, so I...

Hi, I have a storm report that we have been running since 2/1/19 that basically tracks the number of incidents that occur each day. This is a sample from the report (top row is the column they are in): <tbody> G M T U Date Time frame Month Blue Sky / Storm <tbody> 2/1/2019 09:50:14...

Hi, recently started using Excel professional 2016. I am not getting option of pivot table report while loading data to excel. Can any body help. I am getting only two options:- 1. Load to Table Only Create Connection

Hello there, I have the following issue: I have a report sheet in an excel file that combines the information from several template worksheets in the same workbook. I already got the idea how to create a template worksheet every time i hit the "+" button. What i now need is to enable a formula...

Hi, I have a rather specific query i need help with. I have a spreadsheet which has a series of cell values that relate to daily files we receive from around the business. As part of a wider process i run a series of macros to copy and move these files from their source folders. I would now...

Hello, I've been using this site for awhile now and it's been very helpful. Thanks. In most cases, I could find what I need or at least find something close enough that I could modify it to work. I've tried the same approach this round, with no luck. My excel document has 2 sheets that I'm...

I have built a report in Excel. The report includes a set of web links. I used the following formula to create a link and the link works perfectly in Excel. However, when I convert the Excel report to PDF, the link doesn't work. Any suggestions? =IF(OR(O204="Blind Spot", I204<4)...

I need help with a formula or formulas to count and categorize aged dates based on the aging range below. There is a fixed date at the top of the report that it will be compared to that is not a today formula. There is a lot of information above and below where this information will be pulled...

Hello, I one last issue I am trying to solve to complete my project and I am at a loss on how to fix it. Sheet1 = "Inventory Value Report" - I am using this as an "import tab" where a new value report is pasted every time it needs to be used. My issue is that the first macro that runs...

Hello, I recorded a Macro using the Consolidation tool however when I run the Macro, it does not complete the task. Here is what it looks like: Sub Consolidate() ' ' Consolidate Macro ' ' Sheets("Inventory Value Report").Select Range("D1").Select Selection.Consolidate...