fri

  1. F

    hope someone could help -Macro to assist averaging data set's over multiple worksheets

    I am hoping that someone can help me with a macro to average data from multiple time points Simply i have a 4 columns Day, Date, Time, Data The same format appears on each worksheet with in the workbook which i need sort and Average over the data range The data sort should be by date...
  2. T

    Help with formula please

    hi I am currently using this formula to calculate net pay. it only works on the first row cells. When I change to cell range it don't calculate properly. =(AF12+AG12)*Rates!$F$5-(((AF12+AG12)*Rates!$F$5-(11500/13))*0.2)-(((AF12+AG12)*Rates!$F$5-((157*4)))*0.12)-10 Snap of spread sheet...
  3. K

    Place excel shedule information into an excel mnthly calendar

    I have the following information that I want to use to populate an excel monthly calendar <tbody> stake out Mon, Oct 02, 17 0 Mon, Oct 02, 17 excavate Tue, Oct 03, 17 2 Thu, Oct 05, 17 layout/pour footings Fri, Oct 06, 17 2 Tue, Oct 10, 17 weaping, drain, rock/gravel Wed, Oct 11, 17 1...
  4. T

    If cell in row starts with "A" then sum right 1 number

    I have searched and looked all over the internet and this site but can't figure out how to make this work. I was given a tracking spreadsheet that I want to automate counts. Each row has the 14 days of the 2 week payperiod beginning in D9 through Q9: <tbody> SUN MON TUE WED THU FRI SAT SUN...
  5. D

    Double Macros

    I have a macro which works lovely on one of my tabs, which if i put a YES in column BR it moves it from 121 c+d to 121 Disch. this is it: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) '' dvuppx ' Dim Ws As Worksheet Application.EnableEvents = False On...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top