wksht

  1. P

    Date order on multiple sheets

    Hi Please help, I have the code below where I have multiple sheets rows from A:Q and the source is B which is the date what I want from oldest to latest, B1 is the header so it should start from B2. I am gettng an error on the 'Next' Private Sub CommandButton2_Click() Dim wksht As Worksheet...
  2. T

    VBA code pastespecial

    Hi All, I hope someone can help me. I have a code that copies and pastes training programs from the planning sheet to the for that specific athlete. I want it to do this but without pulling through the formula in the cells just the numbers/txt/picture in the cells. The code i'm currently using...
  3. S

    Help with Macro, copy Multiple Worksheets into an Overall Worksheet

    Morning all, I'm an absolute newbie with Macros and have also received a lot of help from previous Postings. I just need this bit of code adapted slightly. So I have multiple worksheets and I need to copy them into one overall sheet. I have captured some script from another thread, see below...
  4. C

    vba to change colour of pie chart segment based on cell value

    Hi, I have a simple 2 segment pie chart (Chart 33) located in a wksht named 'Results'. Its source data is in cells AH3:AH4 (percentages) in a wksht named 'Data'. AH3 contains the result, eg.65% and AH4 balances it to 100% (eg.35%). When AH3 is less than 50% I would like it's segment to be RED...
  5. C

    vba to calculate correlations from averages based on header criteria

    Hi, Please have a look at the pic below and it's hopefully self-explanatory to a degree. I'm looking for a macro I can run that will go to all the wkshts (tab names) in Col W in the wksht 'Results' and work out Correlations based on the Header Criteria in Cols AA and AB. So using the example the...
  6. D

    VBA code to locate identical values---within col A of two worksheets---and replace sheet 1 col A matches with values adjacent i.e., sheet 2 col B

    Hi Folks, I have two systems to harmonize---a logistics system and an accounts management system---which provide different customer numbers: one for invoicing, and one for logistics operations. My task is to incorporate an 'accounts management' report into a logistics systems spreadsheet to...
  7. H

    Date format to dd-mm-yyyy in VBA code

    Hello, Despite the below standing code (Private Sub Process_XLS_Files) copies a date like 2-1-2017 it turns it into 1-2-2017. I have tried to get it fixed by add in an extra piece of code, but that did not help. Both with function of Dateformat as Numberformat. Look forward to your reply...
  8. T

    Complex IF formula help needed

    My first worksheet has a list of projects with Quarter, Partner, Date Live, and Project name. It is in a column style format: WKSHT 1 <tbody> Quarter Partner Channel Live Date Project Name Q1 Company 1 1/1/2018 Project 1 Q1 Company 1 2/1/2018 Project 2 Q1 Company 3 3/6/2018 Project 3...
  9. C

    macro to retrieve data based on column headers

    Hi, I'm looking for some vba that will retrieve data from a table in one wksht and drop it into a table on another. Looking at the picture below, I would like to be able to enter header values in the cells C5:Q5 in the 'Report' wksht then press the button to execute a macro that will retrieve...
  10. C

    formula to find a cell value based on 2 criteria

    Hi, Am looking for a formula that will look at cell A1 (which contains a wksht name eg. 'Data') and cell A2 (which contains a header value in Row 3 of that wksht eg. 'Apples') which returns the value of the cell that is in Row 4 below the header. So, in this example the formula goes to wksht...

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