wood

Hi there, is there a way (either formula or VB) to swap multiple names in one Excel cell? Example of current data in one cell: Victoria Wood, David Jones, Sharon Smith, Caroline S Petit, Martine P Smar, Elizabeth A Gilley, Alex Davies, Andrew P Collins The format I want to convert it to (in...

Hello I have put together a formula but cannot get it to work. Can anyone see where I have gone wrong? I’ve looked at it for so long I can’t see the wood for the trees...

I have two sheets. Sheet1 has a table of data that I will need to lookup, and I will be pasting data from another workbook into Sheet2 that has somewhat consistent column headers but in different orders. I want to put a formula in Sheet2!A:A that finds a specific column in the pasted data and...

Hello everyone, I have the following formula which calculates volumes of materials based on a product, the final part of the formula which needs to equal the word 'timber' also needs to calculate if the value is 'wood'. So it needs to have either 'Timber' OR 'Wood'...

<colgroup><col width="101" style="width:76pt"><col width="82" style="width:62pt"><col width="81" style="width:61pt"><col width="74" style="width:56pt"><col width="90" style="width:68pt"></colgroup><tbody> Good morning Mr Excel, would like to ask how to code the minimization VBA code. The...

Hi I'm trying to improve my macro skills and create a MACRO that would calculate sum from purchase/sales made by a client in different offices. However I've encountered some issues and I'm not sure how to proceed further. Example - I've a data sheet with client name buy amount sell amount and...

Use the data in the ‘Data’ worksheet of the workbook “VBA Training Exercise 2” (attached image) and segregate it on the basis of ‘Type’. Please follow the below points: Find unique ‘Types’ of Roller coasters in the given data. Add new worksheets in the same workbook and name them on the type...

Hi guys, I am trying to create a table that allows me to select values from a list and that value then filters what I can select in the next drop down and so on. Example: I have a reference sheet that looks like the below, which contains all my data. On a separate sheet I want to be able to...

I wood say ;) that one of the most practical uses of an advanced spreadsheet for the Average User, would be to create a sheet that determines the best use of several pieces of wood, such as plywood, based on a parts list. Im not saying its possible for the intended purpose, but if they could do...

Hello, I'm working on a game and I want to make an overview of required materials for ingame items. Column B contains items and column C the required amount of those items. Columns D through P (and proably beyond) contain the required materials for that item. I'm looking for a way to get the...

Hello, I need some vba that will search sheet1 for specific text in col C, then insert value of 1 into that rows B column. I tried the manual recording, but that would not step over to previous column. It defines the exact cell i clicked on. example: search col C (header is description)...