Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MJV8198

    Excel Averageif help

    Hello Skip, Thank you very much for your help. You have been kind enough to help in the past and I always learn from your solutions. Thank you for taking the time to discuss tables! I will figure out a way to use them, not changing references when adding and deleting stores will be beneficial...
  2. MJV8198

    Excel Averageif help

    I have a list of sales $ by store for 3200 stores. I am trying to Rank each store A, B, C, D based on sales level. I want to take the overall average of all 3200 stores, the stores above that level are A or B stores, the store below that level are C or D stores. Once I have the overall average I...
  3. MJV8198

    Excel 2016 - Refresh All not working through Macro

    If I am understanding your problem, the data in the tables refresh but the formulas do not. I had a similar problem that I resolved in this thread: Link The answer is Turn off automatic Calculate, refresh data and manually turn on auto calculate. You can create a macro to turn off the auto...
  4. MJV8198

    Excel Calculation problem

    Hello Everyone, Thank you for your help and I apologize for the delay in providing an update. However I believe I have discovered the problem and devised a solution. To provide some insight, the sheet with the formulas read data from data sheets within the workbook. These data sheets are...
  5. MJV8198

    Excel Calculation problem

    Answers to "Combo" questions: 1)Yes I have circular references 2)I have both named ranges and named formulas. Some of the formulas use the named ranges however some formulas calculate with named ranges some don't, same with formulas without named ranges 3)Name formula is a formulas we wrote...
  6. MJV8198

    Excel Calculation problem

    I have an ongoing problem with calculations not calculating. I have a very large workbook, 20+ sheets, I am using named formulas. I have "enable iterative calculation" checked. The problem I have is some of the formulas do not calculate. If I use a named formula 100 times and it does calculate...
  7. MJV8198

    Macro to Protect all sheets in an workbook and set protection parameters

    Hi Deniall, Thank you for the improvement! My work was a copy of the work you and Skip created. To be honest I don't know why I needed to do what I did but I read the errors and copied you work.. It has been a pleasure to work with the both of you. Michael
  8. MJV8198

    Macro to Protect all sheets in an workbook and set protection parameters

    Skip You get a big thank you as I was able to look at your code and improve Deniall's code. I also like the efficiency of your code unfortunately I have not idea what I am doing so my changes were guesses that worked out well. Thank you for your help. Michael
  9. MJV8198

    Macro to Protect all sheets in an workbook and set protection parameters

    Hello Deniall, I was testing your macro and I was able to change the code to require double entry of the password and check for locked sheets. If you do not check for locked sheets your spreadsheet chas the potential to have 2 passwords. Option Explicit Option Base 1 Sub Protect_All() ' '...
  10. MJV8198

    Macro to Protect all sheets in an workbook and set protection parameters

    Hi Skip I tested you Macro and it works Perfectly. Deniall- Thank you for your response- I tried your macro as well and it works very well except it is not allowing me to filter. Your code is way above my abilities to adjust. Can you provide further help? Update- Deniall I figured out how to...
  11. MJV8198

    Macro to Protect all sheets in an workbook and set protection parameters

    I am using Office 365 Excel 2016. I am using Macro 1 to lock all sheets in the workbook. It pops up a message box so I can enter a password, verifies the password, and protects all the sheets. If the passwords do not match, it starts over. I would like to use this macro in a workbook where I...
  12. MJV8198

    Macro to Protect all sheets in an workbook and set protection parameters

    I am using Office 365 Excel 2016. I am using Macro 1 to lock all sheets in the workbook. It pops up a message box so I can enter a password, verifies the password. and protects all the sheets. If the passwords do not match, it starts over. I would like to use this macro in a workbook where I...
  13. MJV8198

    Macro to import delimited file

    Thank you for you responses, I tried adding text to the open but it did not work. I may not have been doing it correctly. I tried the external data and it seems to work but as SkipVought pointed out it needs customizing. Here is the current Macro. Sub Import_Data1() ' ' Import_Data1 Macro ' '...
  14. MJV8198

    Macro to import delimited file

    I am trying to open a delimited file while in my original workbook so I can paste the data into my existing sheet. I have the following macro which allows me to find the file but it does not go through the import wizard. Sub Import_Data() Dim strFileToOpen As String strFileToOpen =...
  15. MJV8198

    Help with data selection over multiple time periods

    Hi Peter, I tried the Null In the place you located it it was pulling too many records. I tried a couple other places. The good news is I was able to find another variable that allowed me to do the report. I had a few other challenges getting all the data sorted out. I would not have complete...
  16. MJV8198

    Help with data selection over multiple time periods

    Hi Peter I hate to impose as you have been very helpful. As I worked through the detail I realized I was still missing some transactions. so as ot currently stands I have the following. {sasta1.codeiden} in ["c"] and {oeel1.custno} <> 100052.00 and {oeeh1.transtype} in ["CR", "DO", "RM", "SO"]...
  17. MJV8198

    Help with data selection over multiple time periods

    Ok Pete you are the best! it worked perfectly. I have one question, does the formatting, meaning the indents make a difference? I have tried many combinations so I cannot recall if I have tried this specific formula but it is rather simple solution. The main difference would be the...
  18. MJV8198

    Help with data selection over multiple time periods

    Hi Pete thank you for posting! Good news and bad news, the selection did not bomb! the bad news is I am picking up all booking data from 2012 and all the booking data from YTD 2013. All i need from 2012 are records where {oeel1.enterdt} is from 2012 but the {oeel1.invoicedt} is from 2013. This...
  19. MJV8198

    Help with data selection over multiple time periods

    I have a booking report that currently compares YTD booking with Prior YTD Booking. The complete selection formula is as follows and is working without problems. {oeel1.custno} <> 100052.00 and ({oeel1.enterdt} in LastYearYTD or {oeel1.enterdt} in YearToDate) and {oeeh1.transtype} in ["CR"...

Part and Inventory Search

Back
Top