raw

Hi Everyone, Bit stuck on this, I have a document that i add new data every week to, I paste the new data into Sheet "Raw Data" with the headers in Row 13, I have a macro that then checks each header exists in the document already. (basically its weekly figures that get added to their own tab...

Dear Expert, I have a database given below i want to calculate top 5 first top 5 multiply by 10 in next column i.e PERCENT column. first top 5 multiply by 7.5 in next column i.e PERCENT column. first top 5 multiply by 5 in next column i.e PERCENT column. Calculation range changed when party...

hi I have 2 sheets in same workbook. i need vba code which copy data from 1 file to another file as raw for example I have these data in Sheet 1 A B <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name 1 Address 2 City 3...

Hi Guys. I have a sheet with Raw data dumped in. (ever changing number of rows) I need to break this raw data out to printable templates. (Not simple headers but a silly sign off sheet. - otherwise I would try to print titles) What I did is to make 10 worksheets with empty templates where I...

Hello, I currently have a macro that copies data from several sheets (we'll call these the raw data sheets) to "new raw data" sheets. I am bringing over only the columns I need in to a specific order and I am running into trouble because I have to sort the data and my macro copies from row 2...

Hi All, I'm having a bit of difficulty with this one. I'm inputting raw data into a worksheet and using the "text to columns" feature to split it up. However it's not splitting it exactly how i'd like. On another tab I want to do a lookup on that raw data and return multiple cell values based...

Hi all, I'm somewhat embarrassed to ask as this seems pretty rudimentary but I can't figure out a way to fix this. I've built out a spreadsheet that crunches some raw data from another datasheet in the workbook. It works great but this will be a quarterly process with new/updated raw data...

Hi Guys, I am trying to make a template report which can take raw data from a certain program and display it in a much easier to read format. For the most part I have been successful, however I am trying to remove as many manual components from this as possible oh which two remain. My focus...

Hi All, I need to organize some data coming from a raw spreadsheet into a separated table as displayed below. <colgroup><col span="2"><col><col span="3"></colgroup><tbody> Raw Data Rearranged Table A B 1 2 3 1 Green Green Green Blue 1 Red Red Orange Green 1 Blue Blue Red Red...

Hi, I have a complex problem here that I need solved with a formula. I believe an offset formula can be used here. But I simply lack the ability to write a proper formula to achieve the solution. I don't want VBA... I have a column of raw data. The user selects a group size of whole numbers...

I am trying to get the customer spend for a particular product using Sumifs formula :- =SUMIFS('UK Raw Dump'!$X$2:$X$2627,'UK Raw Dump'!$C$2:$C$2627,'Customer Profile - EMEA Region'!B2,'UK Raw Dump'!$AY$2:$AY$2627,"Evault") Where Column X is the spend for the month of September, C is customer...

Hi all, I need small help I am running macro on one workbook (macro book ) for another workbook ( Raw data work book ) but I am getting some issue in middle , that macro is not working for raw data work book suddenly its going to macro book and highlighting the columns but I want to highlight...

Hi, Can you please assist in providing a formula in which I can extract a part of my raw data line item. Please see below of my raw data and how I want the output to look like. Can you please assist? <colgroup><col><col><col></colgroup><tbody> RAW DATA What I want the formula to provide...

Hi all I regularly download SAP reports of varying filters but pretty much standardised list of columns. Many of these columns require conversion to number values, column width adjustments, groupings, alignments etc before I am comfortable to put them into a standard report for sharing with...

Hi, I seeking for a report from raw data which is coming to my system automatically from OEM software. Raw data consist of every 5 min ( Date format is mm:dd:yyyy hh:mm:ss AM/PM)reading/value of meter. But I wan to generate daily , weekly , monthly report from Raw data. Here 1st I want to pull...

How could I rearrange the columns by the columns header name. I need to process a report on weekly basis,the raw worksheet has 23 columns.I abstract a part of them as example. Raw columns sequence： <tbody> QTY Payment Terms Contract No. </tbody> Desired columns sequence...

I have a question, If I have a raw data set on sheet 1 and on sheet 2 I have a dashboard that has formuals and structures the data, but I will be addiing more and more account information to my raw data, but only want the dashboard to pick up my active accounts data from the raw data what would...

<tbody> A B C D E F G H 120 100.25 120 100.25 121 1403.25 122 1007.98 123 500.25 124 266.63 125 985.23 126 2.30 </tbody> The Raw "D" have Number from D2 TO D100 and Raw "E" have Weight from E2 to E100 If I type in A1...

I have a spreadsheet which is reused every month. The "PS" sheet contains a variable number of rows determined by the monthly raw data that will be inserted. The actual data is copied from one workbook to the PS sheet, with formulas interspersed on each row in several columns. Each month I...

I have been having problems that once I add or remove cells on Workbook1, then I have to do the same thing on Workbook 2 and sometimes there are not only few cells added or removed. The problem is that I'm too lazy to do so cos there are so many look alike workbooks that i have to work on while...