advice

I have a large dataset (c.75,000 rows) and I'm interested in the data from three columns. 1. Reference Number 2. Person 3. Value I want a formula to show to me who spent what on each job and return information the below Ref Reference Number Person Value 1234 Joe Bloggs 10 1234 Blog...

I would like to do a macro that will hide the last row and the total row in a table in excel. Any advice? Thank you!

Hello! This is my first post on Mr Excel :) I am trying to collate a list of numbers so they have an exclamation mark at the start and a semi-colon at the end. I wish for these to all end up in one cell so I can copy and paste them into a business intelligence system that requires this format...

Hi all, Apologies if this has been asked before but i cannot find an answer to my question on here or on google. I have the below formula which is a standard vlookup which returns a certain value found for A, B, C etc =IF(VLOOKUP($A7,'CHRISTMAS GIFT...

Hi, I was wondering if you would have any advice when it comes to save a new version of your workings. Lately, i have found myself saving a version after another making my folder looks very untidy. What would you advice to keep your versions nice and tidy? When do you decide a new version is...

Hello, I am looking for advice on a formula to basically minus one from the next highest number. If A1 to A8 have the numbers: 3 5 1 8 4 6 2 7 if the number 2 is removed from the above then i want a formula to correct the order in cells B1 to B8 so they would read: 2 4 1 7 3 5 6 Any...

Hi guys, Would appreciate any advice on the following please. The formula below is functioning reasonably well except for spaces occurring a the end of each returned result. =VLOOKUP([@Column2],'list of part numbers'!A:C,3,FALSE) I have to "Find and Replace" the spaces for the data to show...

Hi guys, I have to make an ERP (by day it looks more complex) like a database in excel with: production type, ok PCs, ng PCs, time and other losses; key machine parts replacing, these parts lifetime; employes's on the shop floor with their leaders; lines, processes; ..... (for abbreviation and...

Hey all, I am seeking some general advice from all those that have gone before me. I work in a small office with REALLY slow computers. I am working on a log that tracks work flow in the office. All should be able to see the current data and all should be able to update it as they complete...

Hi, I have a worksheet that I enter data into each month. At the end of the month I would like to make a copy of the page or the values entered into it then clear the cells & start over again for the next month. The required advice is how should I go about creating a copy / saving a copy etc...

Hi, Can one use AND in a while wend statement: When I use this statement, it does not read the AND statement, so even though there is data in my last column it exits the loops. Not too sure what I am doing wrong, or if I should not be using While and AND in the same statement. Any advice...

Good day. I have 4 forms on one worksheet. I need to place a command button with each form. On click the relevant form needs to be saved as pdf on desktop. Please advice Regards and thank you in advance

I'm updating a macro that is used at my job that was created by someone that is no longer with the company and at the very bottom of the macro there is 2 application run lines: Application.Run "AdaptCaption" Application.Run "ReSaveWorkbook" There are no other macros in workbook and I've...

Hello and thank you in advance if you can help, I am trying to create a column in a query that compiles/concatenates information from other columns when certain criteria are met. The problem I am encountering is how to put it in terms of Concatenate IIf, or if that is even valid syntax within...

Good Afternoon Everyone, I'm looking for some advice on how to create a dynamic drop down list in one workbook (The list values are one column within a table in another workbook) If i click the cell and try and create it using the data validation button in data tools it doesn't seem to like...

Good Afternoon. Working in a finance department, we quite often get issuesthat payments are received, but we have no idea what invoice numbers have beenpaid in that particular payment. This is because the client has not provided aremittance advice (list of invoices they have paid). I am...

Hello Everyone, I have a question about Microsoft Excel 2016. What is the correct way to change the color of the side wall, plot area, and floor of the chart? Any advice on that? I will highly appreciate your response. Thanks to all inputs! Best Regards!

I have to take report exports from Salesforce and calculate things like total sales, number of orders, etc... and I have basic sumifs & countifs formulas for most of the statistics (for date ranges, or product type etc..). My problem is that the raw data reports are structured differently...

Hi all, I have a report compiled by the WHO (World Health Organisation) and I want to use one table for a document (a data report) that I am compiling for healthcare in a number of counties. Currently, I am cutting screenshots of the table and pasting them into my report. It perfectly suits...

Please, give me an advice. I have a combobox where I choose a template. below it I have textBoxt to change the name. I don't know how to go on. I can only copy. thank you for your advice Private Sub btn_create_Click() Sheets(choose_template.Value).Copy After:=Sheets("Content")...