data arrangement

I am needing help re-arranging data in one sheet in the format of another sheet. The issue is I need one row broken down into multiple rows that all tie to the inventory number associated This the sheet I need to format. This is the format I need to get to.

Hello, A forum contributer helped me create a dynamic array for 2 comboboxs which works great. Now I would like to understand how to either create a third combobox or set of third comboboxs based on the selection in box 2? Presently the first row of all columns is the title with the data below...

Dear Team, I have problem in finding expiry stock, I have a file contain two sheets, First sheet shows the batch wise stock with expiry dates and the second sheet shows month wise consumption, for example I have first batch expiry in June-2019 with the qty of 1000, and my stock consumption in...

Dear MrExcel community, I have a problem where I am trying to extract values from a dynamic (i.e. input are likely to change) worksheet to specific charts. Now, the dynamic worksheet is my "Data Input" worksheet and I have several chart plots depending on this. What I need, is a smart way to...

I have roughly two thousand entries in two workbooks that I need to reorder in number and date sequence, I have no idea how to do this, filter only displays the information in whatever fashion rather than actually reorganizing it. The end result needs to be each entry in a date range needs to be...

This is my first post, so bear with me. I have a data WS "Timesheet" that is an employee time sheet using each row as a date. I need to create a new billing invoice WS based off of an existing invoice template "Invoice" and label it as the PO Number with the following: 1) Label the new billing...

<tbody> Date Department POST Name Email Contact City Remarks Admin Clerk abc abc@abc.com 04334325 Dubai Free for job Sales BDE xyz xyz@dfdas.com 89478943 Al Ain on Job </tbody> I got this data sheet, on the next sheet...

Hey, I'm a beginner at excel but I was tasked with refurbishing our budget template. It's a construction company and in the budget we describe what we're doing and what materials we use and price it by units, square meters etc.. The thing is we use a lot of materials, and looking them up by...

Hello, I have been trying for hours and am unable to find a solution. Problem: Move row data from multiple tables to 1 table based on the the the cell value in that row. The data: Table Name: Mr. Big Stuff <colgroup><col><col><col><col><col></colgroup><tbody> EMP ID AGENT SUPERVISOR STATUS...

Hello, I have a report that generates based on InfoPath forms filled out and downloaded from SharePoint. In this report, there are 3 columns each for part numbers and part descriptions (Part 1 #, Part 1 Description, Part 2 #, Part 2 Description, Part 3 #, Part 3 Description). In the report...

Hi, I am creating a summary of temperatures logged every hour for three years at several different locations. I am summarizing by the hour (row headings) and location (column headings). The problem is, some locations only logged temperatures every two hours, while some logged every hour. When I...

I am wanting to move select data to another existing sheet in my spreadsheet. Any that say "Yes" will need the first column data and the reason (last column) to be brought across to the other sheet. In this case the "Sad" and "Angry" data is not needed on the new sheet for the report. Example...

How do I make cells that are dependent on a given result in excel, so that if I for example write 1234 in cell A1 other cells are dependent on this cells value and changes to given result from a third cell? Like this: When i put in the data in cell A1 then the data in cell A2, A3 & A4 is put...

Hello, we are a small mental health facility that began using a new EHR system which has been somewhat disastrous. The problem we are having is looking at a report. We can export to excel (link) https://1drv.ms/x/s!AoxXnX4Qzvyeem4CbgIivHkLvHA but there is a lot of data and we only need table and...

Hi I need a little assistance please. I am working on a macro and: I need to copy data from columns F,G,H,I,J and put in the next available row in columns A,B,C,D,E. Then copy the data from columns K,L,M,N,O and put in the next available row in columns A,B,C,D,E. Then copy the data from...

Good day people. Thank you for your support so far... I need to merge some data values from some spreadsheets to another.. Table A for Year 2013 <tbody> Family ID City State Postal Code Amount </tbody> Table B for Year 2014 <tbody> Family ID City State Postal Code Amount...

Hello people, I am currrently watching an audiovisual lecture and the tutors used some data on excel to work. I had to downlaod the same data from worldbank dataweb. The data is pulled from the data is not sorted out as the one the tutor used in the video, how do I sort it... Raw Table Format...

I have an excel file where all the data is dumped into 4 cells. Column A has a header and then 4 start times (which will be the same every time) and column B has a header and then 4 cells each of which will contain a different number of email addresses and other details every day so the VBA has...

Hi, I am working with a set of data, which cannot be uploaded unless I convert it to a particular numeric value. I am dealing with more than 20 such data sets spread across different cells. For example, as shown below, you will find some common datasets - AR, AF, Web, PR. Now, every dataset...

Hello there, I have a business that sells sun visors online. I need to assign fitment data to each visor to make it easier for the customer to see if the part will fit on their vehicle. There are 2 workbooks that I use. One with part fitment number and the other with my inventory. I always...