details

Hello, (First; I have Office 2016 at home) I want to run a statistical analysis on my photos that I have taken over the years to see what my most used focal lengths are. The focal lenght in the EXIF data is available for windows explorer and can be seen like this: In excel, I just learned...

Hello, I need help with a macro that transposes the information from tab “details” into another tab call “results”. I need in the tab results to Create as many rows per Activity (1-14) as the numbers in the table details in this case 6 columns numbers. These are 4 digits numbers such 2423 in the...

When I prepare a tax return on, e.g., TurboTax, I can click on a tax-form box and "add supporting details," which takes me to a little "mini-spread sheet" on top of the form, usually two columns, where I can enter text in the left column, and numbers in the right column. It will total the items...

I have this data, it has too much details in one column. I'm trying to write a formula that will find only certain contents based on cell A on another tab. If it matches whats in one of those cells, then pull that name or details. How would I go about writing a formula for this? I looked up...

Hi All, I have a task that's very time consuming that I was hoping I could get help with some VBA code. I don't think it's all that complicated, except maybe for the pop-up box I was envisioning, that's a bit beyond me. I'm just not that quick on my feet to get it all written myself. I have...

hi all. I have a userform in which people can select trips/events from a multi select listbox. The list box's row source is a named range containing the name of all trips. each trip has its own tab. The tab names are an abbreviated version of the trip name. I need to have the details of the user...

Hey All I've built a Query that pulls in details about certain products in our range. The problem I've got is that the details for each product live in a text file, it contains details for every product we've ever stocked including some obsolete ones. Because of this my Query is returning...

Hello Excel Guru's, I need your help on how to do this in Excel 2013. I have 2 tabs, 1 for details (source data) and 1 for my summary (target). In the summary tab, I need to mark the Name of the animal with X if in the Remarks column the cell value is blank based on the latest End date. Hope...

I have a spreadsheet as below. Is there a macro that will open my email client and send an individual email in bulk to all in the sheet? Thanks <colgroup><col><col span="2"><col></colgroup><tbody> Body 1 Body 2 Title Email JMatear sdgdfbxfb Login Details example@gmail.com JBrowning fsfbdfb...

Book1ABCDEFGH1INV2268385329-May-194JOB: T00009719528-Jun-1961,394.5271,394.5281,394.529INV102684661129-May-1912JOB: T000097091328-Jun-19141,947.08151,947.08163,341.601718INV26838529-May-19JOB: T0000971928-Jun-191,394.521,394.521,394.5219INV26846629-May-19JOB...

Dear all I am having trouble trying to put together a macro. In Sheet1, I have my data table. I put a simplified version below: <tbody> Gender Breed City Council Microchip Number Status M Dog Council A 1030999876287540 Adopted F Dog Council C 4425588004585700 F Cat Council B...

Hello All I am trying to automate a task that is completed every day on a spreadsheet. I have an inventory tab, which contains the stock details of some 1200 different products. Each day we consume some of these products and update the inventory sheet using the find function and manually...

Hello, I have this bit into my code, that should return simple "Yes", "No" values present in the range. inclusion = Application.VLookup(Dest, details, 10, False) All variables are defined, inclusion as Variant, Dest as String, details as Range. The problem i am encountering is that when the...

I would like to write a macro to display the details of cell in a pivot table when the cell is double clicked rather than having them come up on a new sheet. I want to keep the workbook locked so other users cannot access the hidden pages. The purpose ids to determine if the value is the sum...

Hi, I've created a pivot of a data matrix to get an easy readable overview. I also use this pivot to get to the details of interesting data by double click on the data. Every time I do this Excel opens a new sheet with the detailed data. I was wondering if t's possible to show these details on...

Hello, I need assistance, please! I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer"...

Hi All I have a worksheet that shows a whole load of data summarised in the table below. Worksheet 1 <tbody> Code Sub Code Sub Sub Code Details A Title A 1 Sub Title A1 a Sub Sub Title A1a b Sub Sub Title A1b B Title B 1 Sub Title B1 a Sub Sub Title B1a 2 Sub...

Hi, I've seen variations of this question but haven't found anything that solves what I am trying to accomplish. I have 2 worksheets, a Summary worksheet, and a Details worksheet. The summary worksheet summarizes what is on the detail worksheet (pretty crazy eh??). The Details worksheet is...

Get current system login details with Email id and update in Excel sheet by Vba

Hi. I'm working on coding to automate filling details in users form. Before entering into user form I need select a form name from drop down list. Once selected IE page loads and wait time is around 3 secs. Then need to update details. Now I'm trying to automate this process by using VBA script...