I'm needing to use a formula that will search for the text 'Total' in Column A and if the cell adjacent to it (Column B) has a value '1' to return the word 'Yes'.
I'm needing to use a formula that will search for the text 'Total' in Column A and if the cell adjacent to it (Column B) has a value '1' to return the word 'Yes'.
Where do you want the "Yes" to be returned? In which column?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
in cell E20
Put this formula in E2 and drag down -Formula:
Please Login or Register to view this content.
Thanks, I have 300 worksheets and need to come up with a list of all the worksheets that have a Total of 1. Is there a way of doing this?
You mean you need a kind of report in a new sheet showing the names of sheets which have a total of 1?
Is this total field in 1 specific cell in each of these worksheets or can it be anywhere in the column? What details you want to be displayed in the summary sheet - only the sheet name?
Yes that would be brilliant. The 'Total' text does not always appear in one specific cell. However, it is always in Coulmn A and the corresponding value is always in Column B. In the report sheet it would be good to have the sheet name in Coulmn A and cell A1(Title of each worksheet) in Column B.
Try this -
![]()
Please Login or Register to view this content.
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button
Excellent - that works perfectly. Thank you very much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks