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...
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...
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...
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...
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...
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...
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
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
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()
'
'...
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...
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...
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...
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
'
'...
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 =...
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...
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"]...
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...
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...
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"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.