site

Ive tried all the conditional formats I could find which indicated they would work but none have. Thanks for the help, I'd be lost without this site. thanks again, ATCMAN

Hi All, I want to copy a number of rows from an 'Archive' spreadsheet to a 'Previous_Sites_Visits' spreadsheet based on a drop down selection in the 'Input' spreadsheet. I have a site visit workbook where site data can be entered in a form on the 'Input' spreadsheet. Once the relevant data has...

Hi, I'm trying to calculate the median salary based on a set of conditions - job code = 42, school type = single site. Sample data: <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in...

I have a bunch of Managers (50+)with names in the wrong format, I need to get from: <tbody> Jones, Andy (L7F000915) to ABC1AJones (ABC1= site code) not sure the best way to achieve, open to ideas. Thank you! </tbody>

HELP :D I'm building a formula that would find between two dates and SUM which if found this on your site very useful formula =COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64) The formula helps me find all the dates I needed to count within certain worksheets. for example I have this...

hi , i have a radio button with below elements . i want to click one of them on a web site i try >>doc.getElementsById("datey").Value = 9710 but it just select 9710 value i want to select and click or click on value 9710 , what code i must write? <select size="1" id="datey" name="datey"...

<tbody> A B C D E F G H I J K L M N O Company Location Payroll Number Title Firstname Lastname Gender Job Title Car or Cash Cash Amount Hours per week Salary Age Start Date Years Service ABC Ltd Site 1 010 Mr Paul Smith M IT Director Car 40 £52,000...

This is a duplicate from ExcelForum as well: appreciate your guidance for this. https://www.excelforum.com/excel-programming-vba-macros/1260449-remove-rows-in-a-single-cell-when-matching-text-found-in-the-row.html#post5045631 I have scenario like below: For example a sample cell will be like...

So I have "quote" form that has over 16000 lines on it The Lines basically repeat evrry 112 lines but the site numbers are different.. The quote tool can handle up to 150 sites, My problem is when we need to update or add parts it takes me a whole day or more to update the quote sheet...

I am creating a inventory system for my company and I cant figure out how to subtract from my main inventory. for example main inventory shows 200 form panels i sent 100 to job site A how to I make it subtract the 100 from the main inventory and add to Job site A?

Hi all I have been tasked to generate graph / table that will show the volume of stock moved from 5 sites each site has clients the graph needs to show the effect it will have if a clue t was to move to a different site and the volume which is lost or gained at each site A long winded...

Hi there, I have copied the following formula from a workbook produced by someone else: =INDEX('£m2 Site RUN RATE '!$C$79:$C$99,CEILING((ROW()-1)/(MATCH("zzz",'£m2 Site RUN RATE '!$79:$79)-1),1)+1) The objective of it is to re-produce data in one worksheet into a new 'columnar' based...

Hi everybody, Im hoping someone can help me with a little code to add to this workbook in order to get it to perform the way i would like. I have a database that i am able to export from our online tracking system that contains a list of users along with the sites that are assigned to them to...

Hi everyone it is my first thread on this site I am stuck with an issue and I hope you can help here is the file attached basically it's about stocking products between 3 warehouses. warehouse1 warehouse2 warehouse3 stock of 42 references each warehouse contains rooms in which there must...

Hello, I need to do a macro when I type the site in a cell it extract a table from that site to the rest of the row and I need to do it repeatedly to the rest of the rows till now I can only do it to one row only and it is msgbox This is the code I used If Target.Row = Range("cellone").Row...

Hi I found very interesting function from web. It has been done by some Finnish guy, so some functions are in Finnish. Short translating PYÖRISTÄ.DES.ALAS = ROUNDDOWN PYÖRISTÄ = ROUND JOS = IF EKSPONENTTI = EXP Another Finnish words are cells names ( Name Manager) Link to the this web site...

Hi All, I have a spreadsheet with multiple columns, with Columns "F", "I" and "L" listing scheduled jobs (SJ) and Columns "G", "J" and "M" listing work sites (WS) for the SJ. So, Columns "F" and "G" will define a SJ and a WS and Col "I" and "J" the next SJ and WS etc. These 3 columns "G", "J"...

Hi, I have aset of data on one sheet, with multiple site ID's but each ID will have adifferent set of data as below, once this data has all met a certaincriteria I want to move it onto a new tab the data set is below as an example: <colgroup><col width="64" style="width: 48pt;"> <col...

Hello all, I hope someone can assist in this - and thanks in advance. I hope I can explain this without much confusion. I have a sample survey size of 1,120. 60 people out of 1,120 responses are reporting site errors (so 5% of the population is reporting site errors). It is assumed that these...

I have a feeling there's nothing that can be done, but I'm using a macro to create site-specific reports from a master file. So the macro filters the data so it just has data for a specific site and then it refreshes all the pivot tables in the workbook. So PivotTable #1 is filtering on...