This works beautifully. The only problem I found is when I enter a whole number. For example, if I change the number in the first sample to 3 the result is 0 instead of .19.
Thoughts?
I need to index the correct corresponding column based on the results of multiple row match criteria. In sample one the Incremental Value should reference cell G13 and sample two should reference AD12. Also, there could be up to 70K of these samples referencing the same data so formula...
on a side note, I just noticed the moderator edit requesting to use code tags. I thought that's what I was doing by enclosing the code with []. Do you know what I'm doing wrong?
Thank you very much Marc for your help! Here is the end code if you're interested.
Thanks again!
[Sub Test()
Workbooks.Open Filename:=ThisWorkbook.Path & "\DESIGN-PAD\DESIGN-PAD.xlsm"
Dim varCellvalue As String
varCellvalue = Workbooks("USER INTERFACE.xlsm").Sheets("USER...
Update:
I found the problem. Now I just need to figure out how to fix it. The code is referencing cell AM12 of the file that the code is opening and saving. It needs to reference AM12 on the file that contains the macro which is titled "USER INTERFACE" on sheet also titled "USER INTERFACE"
As a test, I changed the code to this below and it worked flawlessly. The problem is the name of the file does need to be dynamic, based on user input.
[Sub Test()
Workbooks.Open Filename:=ThisWorkbook.Path & "\DESIGN-PAD\DESIGN-PAD.xlsm"
Windows("DESIGN-PAD.xlsm").Activate...
That helps. I think I'm getting closer. What I'm getting now is a "Method 'Save As' of "object'_Workbook' failed" error. The Debugger takes me to this line.
[ActiveWorkbook.SaveAs ThisWorkbook.Path & "\SAVED PROJECTS\" & varCellvalue & ".xlsm"]
Hoping you guys can help. I have an existing Open document where I will assign a macro to a button. I want that macro to open another file and save that file to a new name. Here's the code I have so far but it doesn't seem to work.
Sub Test()
Workbooks.Open Filename:=ThisWorkbook.Path &...
This is probably fairly simple but I'm just not seeing it. Basically, I need to select and delete the appropriate row from the "DeleteProjectList" Table based on my drop down selection in cell C1 on the Interface Tab. I want to tie the macro into the "Permanently Remove Deleted" button...
Here's what I'm using to stop anyone from saving a file. What I would like to do is to only allow a file to be saved through a macro assigned to a button on a sheet.
Thanks,
[Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox "OH NO YOU DON'T!!!"
Cancel =...
I tried to adapt the formulas to work for the rule set 2 but it appears that only some of the rules are working properly. The third rule in the rule set was especially interesting because it doesn't use a consistent mark up increment.
bobhc'
I went over the rules per your advice, and have seen the error of my ways. This will never be an issue again.
Thank you,
NARAYANK991,
Thank you so much! I think the helper columns break it down to a level that this novice can understand. I will work to use it on "Rule Set 2" and let...
Here is a rounding formula that is made to work for "Rule Set 1" on the attachment. I'm trying to edit the formula to work for "Rule Set 2" with no luck. I appreciate any help on this.
Thanks,
Here's the Formula...