details

Hello Everyone, I am working on a template where we need to show the history of all the changes that have been made to the template. Also, another way to use the Change Log data is for comparison purposes. Anyways, is there a way to have a tab in this template (called 'Change Log') where it...

I have 'volunteered' to create a workbook, however the requests keep getting bigger and the task is now significantly monopolising my workload. I'm hoping that your Excel gurus can streamline my efforts and I can finalise the sheets asap. I need to determine what reporting is outstanding, and...

Hi Experts, I have tried and failed to accomplish what I am trying to do. I am not allowed to attach a spreadsheet, but I have one, that I hope lays out what I am trying to do. The highlighting is just for reference and does not need to be included in any help provided. It was just the best...

Please help i have an excell which contain two pages.first page only mrp colum which is balank where i should enter the mrp . second sheet contain all details of diifrent products having same mrp.if i enter an mrp on the first coloum on the firt sheet all details of the all the product of same...

I am trying to clean up data in Power that will eventually be exported into access (achieved employee records). Of the 2866 rows I imported into power query, I have 375 errors in one column and the error reads: DataFormat.Error: We couldn't convert to Time. Details: 1.083333333 *numbers under...

I manage projects. I have a Workbook with a master sheet i named details. I want excel to populate a sheet called savings every time i change the project status on the details sheet to Completed. is there anyway to do this?

Hi Everyone, I have a problem with the below table. Request you to please help me. There are 2 sheets. 1st Sheet contains predefined details mentioned below Row 1: Product Name / Details Row 2: Price for State 1 Row 3: Price for State 2 Row 4: Price for State 3 2nd Sheet is a Daily Report...

Hi All, Sorry if this is a little silly but I have an excel sheet on which we record all our volunteer requests. This sheet is populate by a userform that along with a couple of other forms populates what is a rather large spreadsheet of info. we have a lot of info we need to type into the new...

Hi friends, I am using the excel for my company billing purpose as it is already coded with the macros of auto-invoice generating and will save in the specified name as in a folder....As the files in the folder consists of the data's about the company name , truck no,materials...

Hi Gurus, <tbody> Emp name father name mother name Guardian name James XXX XXX XXX david XXX </tbody> i have a requirement in excel, i want to save an employee details name as Jmaes i need any one of father/mother/guardian columns row value should be mandatory for this requirement...

I have a task that I can’t figure out how to achieve. I have 2 workbooks. One contains a list of "Selected" customers in Col A The other contains a "Dump" of all customers with all contact names and details. Again Col A contains names and subsequent Cols contact names and details. What I would...

Hello friends, Hope all is well! please help me add an Exclamation/question mark (image) to the below msgbox. MsgBox "The Cost Details" & vbCrLf & "And/Or" & vbCrLf & "The Revenues Details" _ & vbCrLf & "Don't Exist", , "The entered Dr. ID is NOT showing" Thanks a lot in advance!

Hi Guys, I have a script where i'm trying to : (1) lookup column 2 in the "Acct Awaiting 2 week review" worksheet against column 2 in the "MIV Case Details" worksheet and (2) when it finds a match copy the details from column N in "Acct Awaiting 2 week review" into column N in the "MIV...

Hi all I am trying to build a spreadsheet to determine the cost of building a bespoke PC. Column A of Sheet 1 has the schedule of the types of components that need to be present, motherboard, hard drive, memory, etc. Sheet 2 has the individual components, Column A details the type of...

I have 2 tables of data and want to create a search function for a colleague to display the specific data from the relevant table. I'm probably overthinking this (it's Friday after all!) Easy to do if I just want to show details of one table using this...

<tbody> Project Name </tbody> <tbody> Task Name First Name Second Name Actual </tbody> There is data in another sheet in Team Data In Dashboard sheet – If I select project then all the details related to project should show up in below table. But name should not appear. <tbody>...

Hello, I am usually not too bad with Excel, but I can't figure out this. Here is the issue I am facing. I have a very large set of data, with many different fields. In short, it shows all unique sales to customers with countries, product lines, month and other variables. I have done a pivot...

Good Day everyone, I'm new on VBA but i badly need this code. copy certain details in one excel in random postion [=sum(e1:xx)] and a positive number not zero i like to put in on a certain excel and on a certain cell the 2 details hope someone can help

Dear All, This is my first post on this forum. I have racked my brains trying to come up with an adequate solution but I haven't been able to find one that works so far. My problem is as follows: I have a database which includes a list of people's names, surnames and I.D. numbers (in that...

Hello When I try to open files using the Open Dialog Box, I cannot see all file details. When I select 'details' under 'Views' i only see the file name and the file size. I would really like to see the modified date, but it's not there. There is no scroll bar at the bottom to slide over and...