details

Hi Everyone, I add my sales into sheet "Quotes" Range is D27:O51 The data for each sale is two rows, row1 the details, row2 Notes, (Not all sales have notes) so what I want is a macro that will copy the last "Row1" sales details and paste it below but it needs to place it 2 rows down to miss...

Hi all. Could anyone please help with formulas using the worksheet calculate event. In column A of sheet1, product codes are scanned. This then brings details of the items through from sheet2 where the manifest is stored using index match on columns L, M, N, O What I would like to happen is...

Hi I have since 1999 downloaded statistics in XML format from a home page and now they have changed to JSON. I can't write code myself and wondering if anyone can help me with VBA code that can pick out details from this file and print the details in a text file. I keep my fingers crossed that...

I am trying to find a way to send multiple emails from a excel sheet, by using Outlook. The excel sheet I receive has a different range of values each time, but columns are always the same. It looks as followed: Column A: Details A Column B: "Computer_name" (This column is best to decide until...

I have a sheet with student details across 7 columns and then in the 8th are their classes. The classes populate down for however many rows there are classes (different for groups of students). What I need to do is have the student details data repeated for every class they take up until the...

When I double click on any value in a pivot table,a new sheet opens showing details of that particular value.What should I do get subtotal in that sheet automatically? Thank you.

Hi, I am using the formula below which works great - up to a point. After 21 cells it just repeat the last cell details. Anyone who can assist please. {=INDEX($R$353:$R$498,MATCH(SMALL(IF(COUNTIF($U$402:U403, $R$353:$R$498)=0, COUNTIF($R$353:$R$498, "<"&$R$353:$R$498), ""), 1)...

Hi, I hope someone might be able to help me. I have a sheets named "Contact Details" and multiple sheets named "*** Patients" (Where *** could be any word or words). I need "Contact Details" to consolidate the data from the other sheets into one sheet based on the following criteria: IF sheet...

Hi, I have been trying to add this CSV data to excel using the following VBA code but could not. Anyway, I only require the first date with the adjacent details. Meaning I only require 2018 Sep 10 details. I am studying about comets and there are about 993 comets being identified. Meaning...

Hi, I I have been trying to add this CSV data to excel using the following VBA code but could not. Anyway, I only require the first date with the adjacent details. Meaning I only require 2018 Sep 10 details. I am studying about comets and there are about 993 comets being identified. Meaning...

Dear All, With the help of below codes, I am able to transfer userform Data to excel sheet name, "Extension Details". But, while data are getting captured in sheet name "Extension Details", Colour and other formats are not same for every new addition. I want formatting for all new addition, to...

Hi, Pls help.. Im new to excel Have an excel with 4 sheets.. each sheet represent a seller selling quota for a day in an excel. and sales varies from seller to seller seller1 ; can have 150 sales for a day seller2 ; sales = 0 seller3 ; sales = 25 how can i use a macro or formula to output...

Guys- i have created a scatter graph and for someof the data labels arent visible? could see the image attached for further details. thanks

I have reviewed many copy/paste solutions on this forum, but so far haven’t been able to solve my particular problem – although I’m sure there is a simple fix ! I have a need to copy details relevant to individual passengers from a manifest and paste the details into a separate sheet. This will...

Hi, been googling for hours, just now sure what this would be called or wether it is possible. I have worbook with 2 sheets, Sheet 1 contains a list of employees in colmn A, with contact details etc in columns B to E Sheet 2 details all the jobs outstanding. I want to be abe to double click...

Hi, Building a dashboard and displaying lots of charts. However sometimes the use might need to see all the details. The details not displayed on the charts. Is there a way to click on the chart or a column/line on the chat and get back to the full details? FYI - all these charts are tied...

Hi Guys, I have a list of details in column L. Is there a way If these details contain a '|' then only show the details before the '|' else show all details. Example of the data in column L below: Current details: Gearbox DSG Oil Change | Routine Service Desired result would be: Gearbox DSG...

I have a list on sheet-1 that I want to move onto an excel calendar (that I created) based on DATE. EX: I want to put the 7/4/18 event details (DATA in Column B) on the calendar. What would be the formula?:eeek::eeek::eeek::eeek: Example below: <tbody> Column A Column B 1 Date Details...

Good morning patient excel people.... I love excel but I know I could use some training on the finer points - but just now I am running a medium sized enterprise and have zero free time. I have a question I am sure someone will know the answer to, and I truly hope you don't mind helping me -...

I have a "Build Sheet" tab in my workbook, this enables us to make prints of all the details needed for each line item. TLDR: Can you help me write a macro to call a range/array 'Build Sheet'!AF5:AF254 or from name managed "BSPrint". Into a macro that then loops to print the "Build Sheet" for...