I am after some help please on the following if any of you kind people wouldn't mind.
I have this formula in a cell working fine
but I want to add another function if possible which would be If V27=Fail...
Can anyone help with this one please? I've got a list of items orders, the columns include the revenue from each item, the order number, and its unique product reference number. In this first piece of work, i have a list of 634 products ordered, that list is made up of 533 unique...
I have a large number of receivables in a spreadsheet that I am trying to locate. I can use relative reference to work down the spreadsheet one record at a time. Would anyone know how to take the active cell, populate a search engine, and auto-populate the name into it and conduct a search. This...
Hey I'm new to macros and have a question. I have many workbooks that each have multiple sheets but are consistent in layout. The info I am trying to pull is located in cells C6:C26 of each sheet in each workbook. I want to show that information, transposed, in a separate 'Master' workbook...
I am currently a dental student and we need to know a lot about Oral Pathology.
What I want to create is a spreadsheet that can be used for differential diagnosis. What I mean by this is that I want to create a spreadsheet with a set of findings such as "inflammation"...
I have a macro that searches through data and finds the word TEST in column A then deletes the entire row (the test record). It worked fine for months but recently has stopped working. Nothing has changed. I cannot figure out why it is not working. Below is the code and a sample of the data...
I am trying to decipher how to run a macro when I have protected all the worksheets on my spreadsheet. I am not an experienced VBA person so appreciate any help on this.
My attempt (which is largely driven by using the 'record macro' option) is as follows:
I need to be able to
1) find the last filled cell in a row ( for 2000 rows)
2) replace the value in that cell with a certain text ("YES")
I am not sure where to start and what formula/function to apply.
Could you please help?
workbook with 6 worksheets of input
1 worksheet with proper inputted data summary
sheet 1 - summary worksheet
cell: A2 drop down menu (different builder)
cell: A3 drop down menu (builder specific series)
cell: A4 drop down menu (series specific models)