Search results

Hi Marc, thank you for responding. I'm sorry I did not get back to you sooner. I believe the VBA should be stored in the Personal workbook for use at any time by me.

I have a folder with a number of xlsx files inside. In a single spreadsheet, I need to create a tab for each file (tab name based on the file name) and then the data from that file copy and pasted into its respective tab. Is this something that can be done with a macro or something else? I...

Thankyou very much with this solution. Thank you so much for this quick reply. This solution works great!

Thank you very much for this. I added the absolute references as noted by joeu2004, but this still failed to work 100% of the time. I am using the IF(AND solution provided by joeu2004 and it is working great.

I am trying to obtain a Pass or Fail output in a single column based on two cells in two adjacent columns. This is numerical data. The data in each cell is a single value. Column A is the Pass/Fail output. Column B and C are values 1 and 2. The value in column B must be within a certain...

Thank you! I did not know there was a subforum.

The set up: I have a data set (example attached) that I update daily by appending new rows. There are two tabs of data (Prof and Meas) and one tabl for charting (Pareto). For the data tabs, column B and C are the same. Column B contains a discriminator (WO Number). Column C is the unique...

I have occasional reports that require a unique identifying number. The format we use for this number is: the date of the report, converted to yymmdd with a non-repeating sequential 4-digit number. Below is an example: Report generated on Feb, 1 2019 would have a number of 1902010001 Report...

Hui, I think "Excel Ninja" my just be an understatement. This worked flawlessly and saved me countless hours of manual work. Thanks so much for your knowledge and willingness to help me out.

I have a folder structure with several hundred files. Each file contains specific measurement data for a particular (unique) serial number of a widget. Each file contains the serial number information in a precise (repeating across all files) location. (Cell B4) I need the file names to...

Another fantastic solution! Thanks!

I received an excellent solution to my first post related to counting unique values. I am however faced with another challenge in that I need to display a list of the unique SN's and then which problems are associated with each. I have attached sample data and a sample output of what I am...

Absolutely fantastic! Thank you so much.

As an addendum to this post, if the result could also include a number of instances a given SN is present in the array that would also be beneficial.

I work with serialized parts. When something goes wrong with a group of parts, I must list all the affected serial numbers. There are several different things that can go wrong so in a single sheet, I list the problem and then the affected serial numbers. I need to be able to look across the...

I have a project whereby I create a number of individualized excel files called "scorecards" These files contain data that is specific to individual suppliers for my company. Each supplier has a unique identifier (SCN number). Each month I need each scorecard to go out to my connected data...

Absolutely awesome solution! Exactly what I was looking for. Thanks so much! Thanks for the link to the dynamic charts, I will poke around and see if I can improve my skills.

I have a number of very simple charts that I must update each day. A sample is attached. I simply auto-fill the top row to create the "new day" and then paste in the numbers for the charted rows for that day. The chart needs to display only 30-days of data. So each day, I must manually modify...

I believe the oldest version we have will be 2007. I would love to hear how to get them to work for 2007.

I created a beautiful analysis dashboard using slicers only to find out that not everyone in the company has Excel 2010 or higher. Users with 2010 or greater will see this: When those less fortunate try to use the dashboard, they are presented with this view: Is there an easy way to make...

Thank you so much. I had a feeling it was something simple but it never dawned on me to use the insert process.

I have several charts that track process performance. With a trend line added it is easy to see how the process is changing over time. Dependent on the individual process and goal, for some processes it is better if a data set trends downward and for other processes, it is better if the results...

I am using slicer with a Pivotchart. When I select the various filters, the chart dynamically changes to display the entire list of rows of data. I would like to limit this dynamic to list only the top ten rows. Is there a way to do this with a pivot chart?

AMAZING! :DD Thank you again, this is a perfect and elegant solution to a problem that has been eating my lunch for some time. Thank you, thank you, thank you.

Thanks for the awesomely fast response. It absolutely works but I added the cells in E through J t this example file as information only to help responders understand what I am trying t accomplish. I do not typically have this data available without creating the separate table first. I was...