raw

Hello, I have two sheets (raw and template). In sheet raw there are two important cells A1 and A2 with values 5 and 12000. I need to to set values in trmplate for cells H1 to H5 values 12001, 12002 to 12005 Thanks in advance.

I am trying to create a filtering scenrio. Ex. The value of Sheet1 in cell A2 is username "Admin", if that happens all Username with admin in Sheet2 will be filtered from the table of raw data.

Hello. My boss give me a raw data and ask me to create a dashboard with function like: If I type the tax ID from a search box (for example) it will get the profile of that tax ID from Raw data and display it in a dashboard. Any idea how should I start and what typle of dashboard I should...

I have the following query: <tbody> Item No Item Class Dept Code Quantity 0001 Raw Material 1 50 0001 Raw Material 2 30 0002 Raw Material 3 100 0003 Raw Material 1 75 0003 Raw Material 2 100 0003 Raw Material 3 20 0004 WIP Item 4 100 0005 WIP Item 4 100 0005 WIP Item 5 175...

I have created a simple Pivot Table & want to Sort the 'Sum of Total' Column from Highest to Lowest. Screenshot below https://ibb.co/iEP20U Is it possible to Sort on the Pivot Table or do i have do the Sort the raw data before creating the Pivot Table ? Thanks in Advance.

With recent economic and market conditions (eg. tariffs), raw material and commodity prices have fluctuated. Some, such as steel (purchased scrap), have fluctuated significantly. If I want to use a formula for raw material pricing, does anyone suggested a specific "forecast" formula. I am...

Hi all, Example : I need to copy the data from the workbook 1 from the sheet data and paste it in the workbook 2 to the sheet raw wherein the sheet "raw" already have some data but i need to paste these new data to the below on those old data. Please assist on this.

Hello! I currently have two macros that I use in order... The first takes a large sheet of data ("100"), and split it into smaller sheets of 101 rows. (100 rows + 1 header). These sheets become titled "Raw 1", "Raw 2", "Raw 3" etc. Sub DataToSheets() Dim src As Worksheet Dim lr As...

Hi all, I am new to VBA with only basic knowledge of loops and have usually just substituted simple loop formulas with recorded macros. Therefore, please forgive me if this question is a stupid one. Currently, I created the following workbook: RawData Sheets (7 of these. each with 2000 rows...

I am seeking assistance in fixing a formula that is resulting in either #Div/O or #VALUE , here is my current formula, =COUNTIFS('Raw May'!E1:E1200,"General Medicine",'Raw May'!AU1:AU1200,"Yes")/COUNTIFS('Raw May'!E1:E1200,"General Medicine",'Raw May'!AU1:AU1200,"Yes",'Raw...

Hi guys, I have a particular problem where I need to count always columns based in the raw after the active cell and return the result for an specific cell. For example, here below I need to count from column 1 to column 3, having as active cell column 1, raw 1. So as the active cell is in...

Hi - I am filtering on values on a Raw Data tab and want to Copy and Paste the values into a different sheet (75% - 95% Opps). I am so close to getting it right.....expect I want to paste the values from the Raw Data tab in a different column / order on the new sheet. Right now its just pasting...

Hi All, I require some extracting and correlating data. In my raw data i have a PA1 followed by a PA6 <tbody> PA1*7*-1*Item one PA6*81001234*Item one I require the "7" and the "81001234" to be returned in specific places in a table so i can then do a look up against them. One thing to...

Hi, I am preparing a BOM project. Sheet5: Raw Materials Column A: Raw Material Code Column B: Raw Material Name Column C: Raw Material Unit (meter, kg, etc...) Column D: Raw Material Cost Sheet4: Semi-Products Column A: Semi-Product Code Column B: Semi-Product Name Column C: Semi-Product Unit...

Hi. I am looking for VBA code what will do the follows. I have 2 excel .xlsx workbooks. First one is containing lets say 11 columns and second is 9 columns with all data. These are all shipments with a shipment number. On first workbook there is 2 extra columns what I like to copy to...

Hi, I have one workbook with two tabs - 'raw' & 'final'. I want to copy all rows from 'raw' onto 'final' - but only for selected columns. Also, the column headings in 'raw' aren't identical to the column headings in 'final' but can be mapped as they won't change, month to month. In essence...

Hi, I'm struggling with ranges, check if you could help me out: If a range contains value greater than zero then are those cells on corresponding rows also containing values greater/equal to zero. What I want to achieve here is to check whether a ProductX that has demand: Also has all the raw...

Hi All: I have a store performance report with about 120 rows of data spread across about 40 columns. I use t Drop Down list to select the specific store I want to look at (there's 80 stores). The report relies on several WHATIFS to select the right data for the right store, and it works...

Hi All, Hoping you could help with my current problem I have with Power Query. I have a raw data file which is updated monthly. I use Power Query to split this raw data file into a number of workbooks based on the centre code as different members are responsible for their own centre codes...

Hi All I'm wondering if anyone can help me with the correct placement of line continuation in VBA. I have a piece of code that essentially just adds up the results of a number of sumifs, however, I cannot seem to find where in the individual sumifs formulas the line continuation needs to be...