sites

I am trying to prepare holiday data for an import into a resource planning system at work. Human Resources have provided me a spreadsheet of all our sites (100+) and which holidays each site observes from 2019 through to the end of 2025. Sites are listed in column A. The date of the holiday...

Any gmail examples out there that permit the ".Display" option instead of ".Send"? I've searched DeBruin and several sites. Looking for a work around or option that would enable reviewing emails and manually sending. Thanks.

just a little help needed. 3 tables on one worksheet that change depending on what is selected from drop downs. is it possible to look up the values from the first table (sales for advisers at a selected site) and then highlight certain fields in the other two tables? so id like it to look at...

I have multiple workbooks all identical but contain data for individual sites. I have recently introduced a new worksheet which I created on one of the workbooks and I wanted to copy it and paste it in to a new blank worksheet for each sites own document but when I do this it also copies in the...

Hello, Iam trying to calculate the days between failures in column E. My goal is to beable to take the difference between the respective date in column A and get thedifference between the date previous cell. Theproblem I am running into is being able to do this considering I want to beable to...

So i have a formula for counting even that have occurred at certain sites. Like different job sites doing different events and a simple one that basically says Job site 1 did this Job site 2 did that we delete everything older then 2 months as the year progresses, just to keep file sizes...

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...

Does anyone here have contact with Mike. Are his blog sites down? I have not been able to log onto his blog or older web sites. Has he shut down his sites or is it my computer? Any information? Have posted the same question on ExcelForum Water Cooler. Will advise if I get results there.

I have the following formula in cell AI2: =IFERROR(INDEX('EOL MATRIX'!$C$5:$C$144,MATCH('ALL SITES (3)'!K2,'EOL MATRIX'!$B$5:$B$144,0)),INDEX('EOL MATRIX'!$C$5:$C$144,MATCH('ALL SITES (3)'!M2,'EOL MATRIX'!$B$5:$B$144,0))) It searches column K for a match and if one is not found, it then...

RE: Sorting + adding new data issue between sheets Hi I have a spreadsheet containing several sheets, one is called "OTR Sites Dashboard" and It has the following columns: - Country Site Name Site Adddress Site Proposed Go Live This feeds all the other sheets ='OTR Sites Dashboard'!E16 for...

Hello Excel Gurus, I have a list of 50 sites that will have the same sale type. What is the most efficient way to copy the data down without having copy, paste and replace for 50 times? I have found this a solution to insert a row after every line using a helper column...

RE: Conditional Formatting Query Hi All I have a spreadsheet where we are capturing Go live dates for a project, the sheet is called "OTR Sites Dashboard", the "Site Proposed Go Live" column is E, we then have another sheet called "Bank Holidays" and that looks up the sites from the OTR Sites...

Hello everyone, new here and need some help! I have some wind direction data (0-360 degrees) for six sites on a mountain. The figures are averages from a raw data set. The data is based on seven readings (half hour increments 11:00-14:00). I would like to create a wind rose-type of radar chart...

The rudimentary code below passes a value to the macro PRINTz_ONE, runs PRINTz_ONE then introduces the next value, .......... and so on. Sub PRINTz_GRP() On Error Resume Next With Range("SITEx_PICKER") .Value = "ROLLED-UP": PRINTz_ONE .Value = "NYC"...

Afternoon, Just after some advice on best practice for how to layout data to create reports from it. I have a worksheet for weekly wage calculation. I have each row configured to store data on the date, name of employee, gross pay, net pay etc, however one of the columns relates to the...

I have an spreadsheet with 40+ columns that are support hubs, and 1400+ rows of support sites. I have distance data for all contained in a matrix format. I want to be able to use a drop down menu to select one of the support hubs, and then have list/match to select all entries within the hubs...

HI All the result of the of the macro is in tab Capitalisation Below macro filters the right data in Site_assumptions and arranges into Capitalisation tab Example AT2 Krottenbach Jul-71 New sites Nov-17 However i need to add in column F "Engineers" and "Site finders" per site and i don't...

Hi guys. I have some problems with IE on win 7, 64bit. There are some sites that have lots of java and flash content. when I open them in IE these sites shows only a blank screen (both IE10 and IE11). I've tried to change security settings in IE to get it to display these sites but so far...

HI All in the following file Budget cube & summary 2018 2 testing_to delete.xlsm - Google Drive I have to create a table based on 1. A list of sites (variable number of sites) 2. A list of costs (water, electricity, detergent, tank cleaning) 3. Months ( Jan...

Thanks for looking at this post. I am looking for some assistance. I have a spreadsheet with a number of individual sites (Actualy 9K) each site can have a number of start dates. I need to identify per site any start dates which would be < to 14 Days. This is for each individual sites. thanks...