wksht

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

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

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

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

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

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

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

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

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

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