data

  1. T

    part number entered pulls corresponding cost/description

    hello Im trying to build a data base of parts warranty info. what im looking to do is when I select a part number via drop down menu in the 'part number' column, the corresponding description and cost columns in the same sheet are automatically filled in. my image below... the PN# column is a...
  2. T

    How to change or replace multiple cell name in Microsoft Excel chronologically?

    I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2"...
  3. T

    Pivot/unpivot help

    Hi Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data. I have tried doing this with pivot/unpivot but struggling to get my head around it...
  4. D

    Display/Extract table content into a different table... possibly a Pivot?

    Hi all, So I have a table similar to the below which acts as a matrix, so Req ID 1 is in F1 but could be in any number of Fx, up to about F80. The status of a Req ID can be updated The Team X is the team who is interested/working on the particular Req. Req ID Status F1 F2 F3 F4 F5 1 Agreed...
  5. H

    Create a ticket sales management system

    Hello! So my first problem is as follows; When I make ticket purchases these are given a purchase number from my supplier & a quantity, for example; Purchase number; 34598 QTY; 4 I then use a simple Vlookup formula to filter through which event this ticket is attached to. Once those...
  6. C

    How to get automatic data that will update for foreign users.

    Hello - I’ve been tinkering around with a sheet at work and I’ve been using various sources for getting data into a specific sheet so a group of 50 people can use. The best way I can query my data is through Microsoft exchange and applying filters to a specific email with excel attachments...
  7. R

    Change Data Structure

    Dear All I have a file with 65 different course I'd with status and level as column header and employees details as rows. What I want is to change this horizontal structure to a vertical one. There are a total of 300+ employees. I need the employee details as it is in the rows but repeated for...
  8. S

    Excel Sharepoint Help: Conditional Formatting & Data Autofill

    Hello, I have a spreadsheet on Sharepoint that I'm trying to make work. The purposes: To allow people from our building can add their name and birthdays. To have conditional formatting that automatically highlights all rows containing dates from the current month. To automatically populate...
  9. M

    csv files - data shifting over to the right?

    Hi all, Whenever I open a csv I get this warning message: Furthermore, my data shift's over to the right, there is an example below but the issue can be random - it may add lots of different empty rows and shift a few rows over to the right, or sometimes the data overlays the rows on top of...
  10. A

    VBA Copy data from 1 Excel file to multiple Excel Files.

    Short version: I am trying to change the code below, so worksheet 41460 can be any Excel file in a certain folder: Further explanation: I have more than 100 Excel files in a single folder, all with the same format. Column A contains a unique number. In one document, there might be 10 of these...
  11. Chris_010101

    VBA Code to auto sort specific cells

    Hi I can't XL2BB as my work won't allow it: I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...
  12. R

    Multiple workbooks and extracting data

    Hello, I have multiple workbooks and they have approximately 25 sheets in each of them. I need to extract same data from each of them. The data is always in the same cell and sheet. I need to extract data to one new workbook. What is the easiest way to do this? EDIT: Also I need to extract...
  13. J

    Vlookup from multiselect data validation list

    Hi guys, I am working on a project for my work which is a form that users can use to help them make decisions etc. I have this code that provides the ability to make multiple selections from a data validation list, so instead of the default excel position of being able to select one option...
  14. K

    Data formatting Question

    Hi all! I am using a data scraper to pull info from the web and an struggling to transform it in a way that's easily read. Right now the csv file comes out like this: Title - data Title - data Title - data And then it repeats in blocks like that. What I want is to move the titles into the...
  15. ibmy

    Find Number Pattern in Data - need 1 Column solution

    Hi Mr Excel, How do find Number Pattern in data which is : 1. Starting a Negative value ( - ) 2. Follow by at least a Zero ( 0 / 00 / 000 / 000..... ) 3. Follow by a Positive value ( + ) 4. End with a Negative value ( - ) Number Pattern : - 0 + - When Number Pattern found, assign "1" at...
  16. G

    Kindly help me solve this Interesting Excel Question....Been stuck at it and cant seem to figure it out

    Context: Pathshala Learning Center (PLC) is a community learning center, has been serving children & youth across 13 villages in the Gular Dogi region (District - Tehri Garhwal, Uttarakhand) since 2016. It has been striving to facilitate an environment of opportunities and holistic learning...
  17. M

    Weird excel issue

    I have come to this weird issue where excel isn't using the target cells for my formula until i double click into each cell that that kind of refreshes it into working. in the example below you can see rows 9,10 and 11 have nothing in column K, however if i were to double click into one of...
  18. B

    Publish Power Query Connection for Use By Other Workbooks

    Hello-I have a series of power queries that culminate in a large dataset of more than 1 million records. I would like to publish access to the power query as a connection, rather than as a workbook table given it’s large size and growing. In a nutshell, I’d like to allow access to the power...
  19. Chris_010101

    Excel Data>Sort Issue

    Hello Wondering if an Excel expert can help. I'm wondering if this might be due to an update but i'm not entirely sure. I have a workbook at work which is used to track absence. There is a master data sheet which is refreshed with a system report every day, so on the absence sheet, all the...
  20. M

    Data Validation List Based on Meeting Criteria in Adjacent Cell

    I am trying to make a data validation list on Sheet1 that references all non-blank items in column A on Sheet2. I have accomplished this pretty easily (although, is there a way to exclude the header without just selecting a long range like "A2:A5000"?). Now, I want to trim that list to only...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top