current

I have my code mostly complete - except for a few minor edits that have me stumped! I need all sheets copied to the new workbook except Sheet2 (ODBC_TABLE). If possible, I'd also like no headings and password protected. Any help would be appreciated. Thanks Sub New_Syscofile() Dim Output As...

ok, I am sure I was doing something stupidly simple wrong. but I need to get results based on an entered data point. example in the spreadsheet: enter data in C16 search column C for the first repeat of data starting at current entry(C16) if found(C9) pulls data from column G(G9) and enters...

Hi Experts Here arrives a new problem. I copy pasted a vba from 1 sheet to another. The earlier sheet it was doing fine as there was only one table in that sheet. Now the problem is that current sheet has many tables and I want it to go to the last row of current table in the current column...

Hi all, I have some coding that I have developed over time - but I'm stuck at one particular point. In 'column B' I have a list of dates, they are all in the same format (UK). What I want is some coding that deletes any row that has a date from the current year (I'll be using this code going...

I have a report that I have exported as an Excel file (.xlsx) from Insightly. I am trying to see if the date exported (Col C) is less than or greater than the current date =Today() in (E1). I am using the formula =if(exporteddate(D2)<currentdate($E$1),"less","greater")...

Hello everyone! I just purchased Office 2019. In Excel, where did the small "x" go when closing the current workbook. Each time I open an Excel document, it opens another window in Excel. Is there anyway to go back to having the small "x" to close out the current Workbook and not close out the...

How to sum range only data in current month? for instance; <tbody> A B C D E F G H I J K L Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1 0 0 2 4 5 0 0 8 9 0 2 </tbody> I want dynamically sum the range A:L but the result should only count from first (A) to the current month (Aug)...

Hi there,Sorry if I am posting a new thread and it has already been answered else where. I have looked and looked, but no luck so far.I have a time & resource planning tool which has fixed data on columns A to G (name , activity , priority etc). From H on wards are week to week columns.What I am...

Hello Team, I an encountering this error regularly. I tried to debug the code but unable to resolve the error. Request you to guide me to resolve the issue. I have similar file with this code and it is not showing any error. Here is the code for your reference. Please share your response with me...

I am needing help on a formula that ranks a set of cells. some will have data and some will not depending on the time the report is ran. I am attempting to exclude the data with zeros and no data from the rankings. Current formula used : =IF(Q6=0,"",RANK(Q6,$Q$6:$Q$20,1)) <colgroup><col...

Hello guys, I sometimes have for loops nested in for loops, but once i find my answer id like all of the loops to exit, not just the current one. My current code looks like: For Each item1 In fulllist1 For Each item2 In fullList2 If item2.Text = "hit" Then done = True...

I would like to calculate current depreciation which should not exceed the cost of the asset, which is in cell b2. Thanks. The current depreciation is being calculated as under: =IF(A8="","",ROUND(IF(A8=1,SLN($B$2,0,$B$3)/12*DATEDIF($B$4,$B$6,"M"),SLN($B$2,0,$B$3)),0)) <tbody> A B C D E F...

I have this code that creates a file with the Current Date and Current Time. (along with other info) I would like to know how can I update the file with the Current time only? Can I request of assistance. Thank you kindly. Open OPath & OFile For Output As #1 Print #1 , Date...

Hello, I am trying to write a delete query to remove records from a table based on records in another table. There is a common field and I want to delete records in table 80 that have no matching records in table 01 (Below). The query works just fine but when I switch it to a Delete Query, it...

Hi All, i am trying to work out the difference of sales between current week and the week prior. my formula so far is: =COUNTIFS(Historical!C:C,B2,Historical!$A:$A,A2,Historical!$I:$I,WEEKNUM(TODAY())-1) im struggling to work out how to compare it to the current week. any help will be...

Hi all. I am trying to save the current user to the sheet Customers when form is saved. I have tried a few things but to no avail; Sheets("Customers").Cells(i, "H").Value = tbncem.Text 'I have tried Sheets("Customers").Cells(i, "H").Value = currentuser 'This actually saves the displayed...

Hello I was wondering how to make a macro SaveAs my file into the folder that my main file is in. Currently my code saves to my documents folder. My current code: Sub SaveAs() ActiveWorkbook.Save ThisFile = Range("B4").Value & Range("B8").Value ActiveWorkbook.SaveAs Filename:=ThisFile End...

Hi Friend, I need help for filter all years date data and delete except current year Sheets("1_Clarity_REport").Range("E:E").AutoFilter Field:=5, Operator:=xlOr, _ Criteria1:="<=" & Application.Eoyear(Year, -1), Criteria2:=">" & Application.Eoyear(Year, 0)

I am building excel sheets to simplify my life with co-management that are not "EXCEL SAVVY". I came across a dilemma that made me feel like the un-savvy employee in this matter. For scheduling production needs i am using this formula to manage capacities of storage so i can reference this cell...

Hello, Is it possible to fix permanently the data already copied in a cells (using an excel formula) during the current month, once the current month changes. ie. if in C7 the data copied from G8 on 20-07-19 (or any date of the any current month) is "pen", when the current...