Fix macro to make it work on any workbook regardless of file name
I am trying to make this work when any workbook is opened not just on one with this filename. Can anyone help?
Within a single excel cell, checking if values from a range are found in another range and equal a value found in another range
I have a list of available codes that people can choose from (A2:A21), some of which are required and some of which are optional when they submit their selection of choices (flagged as “Y” or “N” B2:B21).
I would like to be able to have a flag in D2 to say whether the choices they have made (D5:D16) contain all the required codes (“Y” values in B2:21). Any number of optional modules (“N” values in B2:B21) is permitted.
Macro not working when try to create a new one
I have already an existing macro that is assigned to a shape that I used as a button and then when I created a new macro and then assigned the macro to a shape or even in a button on the developer tab the button does not work and the existing buttons also stop from working, but if I run the macro manually by using the “run” option in the developer tab or in vba in works fine.
How to create a list of unqiue values from a list of multiple sheets
I’ve got tree planting list across multiple sheets e.g.,
Need to pull data from another sheet based on the condition and entered values
i am doing some Excel work to estimate some project and I have to define the Task complexity after that based on the complexity I need to pull the Hours from other sheet
What methods are available to show colleagues the advantages of a database+application solution over Excel?
I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I’m sure they haven’t contemplated that there might be a better/easier/more productive way of managing their data. Naturally, I advocate an application of sorts that can leverage the features you find in relational databases and interactive front ends, tailored to the needs of the various workflows currently distributed over disparate spreadsheets.
What methods are available to show colleagues the advantages of a database+application solution over Excel?
I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I’m sure they haven’t contemplated that there might be a better/easier/more productive way of managing their data. Naturally, I advocate an application of sorts that can leverage the features you find in relational databases and interactive front ends, tailored to the needs of the various workflows currently distributed over disparate spreadsheets.
What methods are available to show colleagues the advantages of a database+application solution over Excel?
I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I’m sure they haven’t contemplated that there might be a better/easier/more productive way of managing their data. Naturally, I advocate an application of sorts that can leverage the features you find in relational databases and interactive front ends, tailored to the needs of the various workflows currently distributed over disparate spreadsheets.
What methods are available to show colleagues the advantages of a database+application solution over Excel?
I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I’m sure they haven’t contemplated that there might be a better/easier/more productive way of managing their data. Naturally, I advocate an application of sorts that can leverage the features you find in relational databases and interactive front ends, tailored to the needs of the various workflows currently distributed over disparate spreadsheets.
What methods are available to show colleagues the advantages of a database+application solution over Excel?
I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I’m sure they haven’t contemplated that there might be a better/easier/more productive way of managing their data. Naturally, I advocate an application of sorts that can leverage the features you find in relational databases and interactive front ends, tailored to the needs of the various workflows currently distributed over disparate spreadsheets.