Search results

@Deepak and @Hui THANK YOU!!!

Hey Everyone... Question... trying to figure out how to create the following format for a date series. 01.01.2016 01.02.2016 01.03.2016 01.04.2016 etc.. I've played around with the date formats with no luck... not sure what custom format to try and create. Curious to hear your thoughts...

@chirayu... thanks! -DM

Hi Everyone, Quick question.... How, or can you, create a chart using the time slicer to overlay two periods, like the last quarter of 2013, 2014? Thanks! -DM

Hey Everyone, Question... from time to time I get some data imported (external source) as a number, when in reality it's a representing a date. Phrased differently, the data imports without the proper format. For example, after the import is complete the cell value is 20151231. I'd like to...

Hello All, Question about Pivot Tables/ Pivot Charts. I have an excel report that covers two weeks of data (hours charged at a project level)and have created/ converted this to a Pivot table. Would like to insert a Pivot chart that will identify the hours comparison from one week vs. the...

Hey Everyone... I'm a little stumped and can use a hand. I have an excel report that covers two weeks of data (hours charged at a project level). It's been converted to a Pivot table. Like to insert a Pivot chart that will identify the hours comparison from one week vs. the next. Make sense...

Hi Everyone, Question for you. I'm trying to figure out how long a person worked at a company to the year and month. For example, they were employed from XX/XX/XXXX date through XX/XX/XXXX date-- how many years and months were they employed- displayed like X years and Y Months, say 7 years...

Hi Narayank991, Thanks for your help and sure let me provide some more info. The average that I was looking for is based on an average of the tickets that come in for a particular date range. I am now doing reporting and average ticket count is based on the date criteria. Hopefully I am...

Hi Everyone, I am trying to figure out a way to include an "average" line in a pivot chart and have attached a generic file that I am using with a pivot table in a separate worksheet. This file has report data, which I am using to create the pivot table and am trying to show an average line in...

Hi Everyone, I am trying to figure out a way to include an "average" line in a pivot chart and have attached a generic file that I am using with a pivot table in a separate worksheet. This file has report data, which I am using to create the pivot table and am trying to show an average line in...

Hi Everyone.... here is the latest. Here’s a new screen shot with changing the sheet name. Sheet1 is definitely the one we are trying to apply the macro to. Also, the web site I have been primarily trying to follow as DIY: http://www.rondebruin.nl/win/code.htm The screen shot is capturing...

@Narayan.... thanks!!! that helps... let me give that a go.... -Dave

Hey guys.. I'm back, can use a little more help. Please see italicized text and photo... ... I took a screen shot of how the macro looks with my modification to it. Dual monitor set up – on the side you can see the directory that I need to pull the image files from. On the left is Visual...

@bobhc.... thank you! @Deepak....thanks very much!! I appreciate your time and effort Best, Dave

Hey Deepak.... Here you go... along with some supplemental text. "The model number column actually FOLLOWS the picture column, so my mistake in describing that previously. There will be some formatting done after all the pics are inserted. I can select Insert->Picture->Recent Places which...

Hi Everyone... just had this question popped up and I'm thinking the best option is a macro. Love to hear your thoughts/ probable solutions, alternatives... please see italics. I have a project where 450 pictures are needed to be inserted into their own column, matched to a part number in...

Hey Debraj..thanks as well. With respects to betting, if it cost $.50 to get around the world, I couldn't get out of site... so not sure if doubling my bet, along with me losing, would really line your pockets. :) Thanks again! -Dave

@Somendra--- Many thanks! -Dave

Hi Everyone, One of my clients asked for some help and I'm stuck. I'm betting the Index (or Hlookup nested with IF) formula will be needed to solve it but have no clue, so here goes. Pardon if I'm a little long winded. If you look at the attached file, focus on row 10 since it will give...

Hi Everyone.... Not sure if this is possible, but just like to know your thoughts. I'm currently using Excel 2010 and know you can do this in other, older versions. I would like to open a new instance of Excel every time I open up a saved Excel document. For example: I open spreadsheet A...

Hi Alexis, Thanks, I appreciate it. I'll definitely pass it along. Subsequently I asked him to clarify his original email/ send more info. Below is his response. What I basically have is a PivotTable where I have as my coulmn headings names such as bank name, type of product, reason why my...

Hi Everyone, This post may be a little premature, but figured I'd ask. One of the people I work with deals with Pivot Tables and need some help. Below is the email he sent; of which I cannot offer a solution since it, from my perspective, does not offer any real substance. Thought maybe some...

Hey Somendra and Luke. Definitely appreciate the efforts!! @Somendra -- that is a great formula! @Luke M-- I'm digging the Occam's razor action! Thanks, Dave

Hey Luke.... thanks man... definitely appreciate it! Best, Dave