no macro

Hi - is there an option that allows "Refresh All" to recalculate a workbook prior to refreshing pivots & queries? I have a workbook that is using manual refresh. When I click refresh all, I'd like the workbook to be recalculated first (instead of relying on a user to remember to recalculate the...

Team.. Need your help again. I believe it is possible for Excel to find key words as described by user and paste the same in the dedicated cell. And I also believe this can be done without using a Macro. Please help out on the below.. I prefer not to use Macro's if possible please. Keyword and...

Hi. I writing a macro to save my file and to do some procedures after it, but I ran into a little error. When I run the macro, and it asks for the file location and I escape, the macro goes to the error but it stills cleans the sheets (limpafolhas), which I don't want to, unless the saving is...

Hi, i would like to duplicate the content of certain cells depending on some criterias. I tried VlookUp, Match and Index but i cant get it. If possible i prefer a solution without vb macros. I try to explain using the below sample table <tbody> A B C D 1 Selection of Category (input)...

Hi, i'm doing a football spreadsheet, I need a formula that will recognise P in column A3 to put Manchester into the next round and appear in Column A5 Whilst if No "P" appears it will pick the highest score from either A4 or A5 to put through to the next round <tbody> Manchester 2 P...

As stated I'm trying to move a row from one worksheet to the last row of a table on another worksheet. I'm trying to create a simple data entry sheet. I have an "Input" worksheet that has 4 "entry" rows and "Server" worksheet that has 4 tables in it that correspond with the 4 "entry" rows...

hello I am trying to create an automated solution table with solver. column R1C1 input dollar value - changeable A%*R1C1 /0-100/-changeble B% (100-A%)*R1C1 sum A sum B if if .... C15 Result a+b-if s Goal : Create a table for numbers 0 in 500 steps to 100 000 with lowest Result...

Hi I have been strugling with this, and I was hoping someone could be of help, basically on my data tab i need to pull in the right name based on the code matching from the map tab and the date falling between the start and end. For example the first name the formula would find would return Joe...

I pull a report from an database for work that contains fundraising data. Column A is "First Name", Column B is "Last Name" Column C is "Email" and Column D is "Total Amount to date". I pull the report every week and each week there is added data for new entries and the total amount raised for...

Hi I want to be able to use the tab key to move from one active x text box to the next active x text box in a spreadsheet without using any macros. The controls are not in a vba form. The document will be protected and locked in its final form. I managed to fluke this in Word and have also...

I am curious if this is even possible… I have been working on solving this for weeks. I work on a regular basis in an excel sheet that contains a column B that holds text. The text has HTML code in them on several places in the text, some 3 HTML codes and other 5 or 6 HTML codes. See example...