output

I need to come up with something in VBA to essentially sum corresponding cells on identically formatted excel documents and output them onto a seperate master copy. Ie Spreadsheet 1, 2 and 3 all have information in cells A1, A2, B1, B2 so would like all the A1's to sum and output onto cell A1 on...

Morning Excellers, I have a sheets used for tracking tests done regularly at 12 centres (monthly, quarterly and yearly tests). I want to make a audit page that will check tasks have been done within allowed timeframes. Ideally this would be come automated but for now a manual approach would...

Hi I am very new to VBA basically copying bits from other workbooks so please bear with me! My query is as follows: I would like to reformat my output of <colgroup><col width="268" style="width: 201pt; mso-width-source: userset; mso-width-alt: 11434;"> <tbody> 12.9000299280694 -...

I have a range where I need to derive the level/depth in the hierarchy for each cell where some cells are comma seperated , for example: <tbody> Task SubTask ParentTask T1 T2 T0 T5 T3,T4 T8 T2 </tbody> In this example range, the level of T0, T5 is 1. The level of T1,T3,T4 is 2. The...

Hello, I have a Column K named 'SHIPDATE' and the first date starts in K2 and is in the format 9/27/2017 0:00. I need to make three separate columns from K2 named MONTH|DAY|YEAR So for Day I used this formula: =DAY([@SHIPDATE]) But the output for Day is 1/27/1900 0:00 I'm...

Hi So I'm having some issues using Excel's advanced filter functionality in that it's sometimes including records it shouldn't. Lets say the data is as follws - 10 columns of random data, followed by 12 blocks of four columns titled BillingCode1,JobCode1,Charge1,Description1 to...

Hi Guys, Can you help me tweak the code below for below table? <tbody> No x 1 Sean 2 3 Output Submitted To Department 4 Output Submitted To Deparmnt 5 Output Sbmitted To Dpartment </tbody> ------------------------------------------------------------------- Sub...

GA, looked through the forum and found many examples of sumifs still not understanding why one of the formulas below will not work. All produce a 0 value output Have tried multiple methods =SUMIFS(F:F,C:C,">="&I55,D:D,"<="&J55) =SUMIFS(F1:F724,C1:C724,">="&I56,D1:D724,"<="&J56)...

Greetings, I have a macro that I would like to use to convert date values in columns of data. I would like to be able to set the column value to convert with the integer variable 'a'. The material inside the with statement is not functioning. I have two questions. 1)How do I set the output...

Hi All, I need an output that displays the URL in column A (Old URL) that most closely matches the URL from column B (New Url) The product name & code number stay the same in both A & B there are just some extra categories in the column B list The output needs to be Something like Column A...

Hi all, I have been struggling with this and i will be grateful is some one can help me. It must be done it WITHOUT pivot tables or filters, just formulas!! I have to create ranking position, where the output is the Name of the Top 3, who got the highest scores. With parameters or...

Hello, I have a formula that would output me text = "Excess" if a given range of cells are empty. However I would like to add a second condition to the existing formula. Condition being if the cells have also blank space or spaces in them then output text = "Excess" aswell. for instance the...

Good day! i have a table with 4 columns. col1 col2 col3 col4 Please help me with a formula that outputs the following: col1=empty & col2=empty & col3=empty & col4=empty => output a col1>0 & col2=empty & col3=empty & col4=empty => output b col1>0 & col2>0 & col3=empty &...

Hi All, I'm new to this forum and VBA... I have a query regarding VBA Countifs and ForLoop. There are 2 Worksheets : Worksheet 1 have rawdata and worksheet 2 is where I need the output. In Worksheet Column(C) have dates and Column(I) have Output, from where I need the count in Sheet 2. in...

This formula shows the "ABOVE DUAL SHADES" text in a line on my worksheets. Is there a way to output that text in Bold. Thanks =IF(FINALORDER!$B25="ABOVE DUAL SHADES","ABOVE DUAL SHADES",IF(FINALORDER!$HD25="","",(FINALORDER!$HD25)&" - "&(FINALORDER!$D25)))

I need to reorganize data output as listed below: Source export: Column A | Column B Patient A | Diagnosis Code 1 Patient A | Diagnosis Code 2 Patient A | Diagnosis Code 3 Ideal Output: Column A | Column B | Column C | Column D Patient A | Diagnosis Code 1...

I have a large dataset (about 500k rows) w/ text and I am only trying to extract the portion of text whenever the code is null or has a "C-*" code. The nulls or "C-" codes don't appear in every row, so for those a simple "OK" in the output to differentiate those will do. Each cell of the...

In cell C1 I have the follow string: O:\Data\Search Requests\2019\20190107 - Christine_Smith I'm looking for a way to get the date 20190107 in cell A1. Cell A1 is date formatted so it needs to recognize it as a date, not sure if the only way to do that is 01/07/2019. Maybe a search starting...

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> 8:00 60 8:30 79 9:00 79 9:30 100 10:00 100 10:30 50 11:00 50 11:30 50 12:00 100 12:30 100 13:00 100 13:30 50 14:00 50...

I'm trying to sum multiple columns if the first column is the same. I was trying to use the consolidate function but I also need the order date and customer name to remain (it changes if I consolidate). Here's an example of an input: Here's what I'd like it to output: The number of rows will...