specific

Would appreciate if someone may be able to assist me with my Excel problem. I have been given an exhausting row of raw data (250,000+) from which I need to try and unravel key indicators. As such I require to extract specific text from two conditions in a string. An example is below...

I am working on a spreadsheet for monitoring personnel records, especially in relation to the disposal of the records. I current have the spreadsheet which calculates 6 years after an employee left, and which will compare this to today's date to flag they have been gone for 6 years. Our policy...

Hi Guys Just curious if someone knew had to do a complicated "sumif" calculation where you take the criteria in a list from the columns and the rows. What I am trying to do is add up all the quarters in a specific year (say in this case 2018) and add only 2018's quarters along with the...

All - good evening Having some issues getting vba to work that specifically points two different data query table connections in one file to a specific separate source file. The specific source file is located in c:\Crop Chemical Database\Crop Chemical Database.xlsm I want the receiving...

Hello, I have a worksheet with two tabs, on the second tab I have all my data and on the first tab I have a blank list with headers. Once I input data on the second tab, in specific cell(s) (e.g. A1) I want that data to be displayed on the first tab in specific cell(s). The trick is I do no...

Hi. Im needing help for VBA to delete current work sheet if not a specific name. Quite a lot of examples out, but can't seem to adapt. Thanks.

i have so far =SUMIFS(a2:b18, a2:b18, a2<b2)<b2)<b2) i want to get the sum in column a. in which b is greater than a. and a is greater than 30. example: a b 10 11 11 10 12 10 60 12 100 150 60 120 in this exmaple the sum should returns 110</b2)<b2)

Hello I am having the hardest time trying to find a way to copy and paste a specific range of data in a specific sheet in a specific workbook. I want to paste it into an existing PowerPoint on a specific slide. I have outlined the parameters below, hoping to find a vba code. Workbook...

Is there a way at the end of the macro, everything is working perfectly for me, to save the file in a specific folder on the hard drive with "YYYYMMDD_Forward Order.xlsm"? The YYYYMMDD should be the date the macro is ran Save and close it also? Thanks!

Hello I want excel to mark the cells that add up to a specific sum, in this case the sum is 1589. What is the best way to do this? <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> A B 1 Serienr Belopp 2 1555 500 3 2555 100 4...

Hello, Forum, I am unable to find a VBA which would select cells which contain specific characters in a range. Could some give a hand? Thank you for taking the time.

Hi everyone! I'm looking for an option to reduce time and mistakes. Daily I have to do payment batch. I get the information through a web page, so I copy it everyday to a excel workbook and filter the information and copy 1 by 1. As a batch it has pre-charged and fixed information, so I need...

=LOOKUP(9.99E+307,'BALANCES - CC'!$C2:INDEX('BALANCES - CC'!2:2,MATCH(9.99E+307,'BALANCES - CC'!2:2)-Z$2)) I have no idea... I thought Lookup wanted to find a specific SOMETHING within a specific range. But the range is what I don't get. The portion above: INDEX('BALANCES -...

I am trying to determine the best way to look up potentially large amounts of data, and I dont know if sumifs on an entire column (like A:A) is any slower than a specific range (A1:A300) for example.

Hello, I designed a cell adds value to a specific column in a specific sheet. I want to add one more of the highest number in a cell.

hi i have been trying to do this for few hours and i just give up i know you gays you could do it with your eyes closed :) 1) i want to know how many Specific item has been sold in Specific Date Range 2) i want to know total profit in Specific item has been sold in Specific Date Range Example...

I need to create a "print" button using ActiveX (Our company blocks the other macro button) to print off a specific cell containing a barcode. The document is a tracking file so when each line item is filled out, it generates a barcode. Beside each barcode, I want a macro button of some sort...

Hi, I need a automatic vba code to disable the existing vba file after specific timeframe and specific date. Thanks

In a range of cells, a1:f1 specific words may be entered. I want a siple count of the number of times a specific word appears in this range at cell G1. Any assistance will be greatly appreciated.

Hi, I need some help. I need copy specific rows (filled rows) from sheet2 and insert to sheet1 specific place between 8 and 9 rows(Sheet header is from 1 row to 9row and sheet footer is from 9 till 18 row. All information from Sheet2 have to be placed between them). This is like proposal form...