correction

Hi All, I want to post to the first blank cell in Row 'L' after L3, but it is pasting to B3. Any correction pls?

Hi All, Hope you can help me. I'm trying to automate the creation of pivot table. However, when there's new data, it does not capture when running the program again. Here is the code: Sheets("QA Error Correction Tracker").Select Range("A1").Select Range(Selection...

Hey All, I've been working his formula since yesterday and I've decided to break down and ask for some help. Excel keeps asking to correct the following formula: =MAX(F4*R4), ((((O4/MONTH(TODAY())))*12)*(F4)) to: MAX(F4*R4)*((((O4/MONTH(TODAY())))*12)*(F4)) I can't seem to get it right or...

Hi, I have been struggling with this VBA code for quite some time now and would appreciate any help with it. I have attached a sample spreadsheet I am working with. First sheet shows the raw data that comes from the SharePoint and second sheet shows the report I am trying to build form the raw...

Can anyone help me correct the following formula: =IF(C2>100,IF(T2="Change of Ropa",ROUNDUP(VLOOKUP(DATE(2006,1,1),$Q$2:$R$28,2,0)*1.86,-1)+G2),IF(C2>100,IF(OR(T2={"Superannuation","Appointment","Annual Increment","Enhancement of Qualification","10 Years' Benefit","18 Years' Benefit","20 Years'...

I have a workbook that has been "missing" column A for several months. I have tried all possible suggestions presented on prior threads here, done additional internet research, but have not been able to make the column reappear. I ultimately recreated it, but now that I have downtime before the...

Dear All, Can i make a condition for range of cells in and function, Correction require in below function =IF(AND(B6:B525>=15000,B6:B525<=16000),"SERVICING","Change Oil after every 2500KM") Rgds, ak

Hello All, Getting error on this, can someone there to guide. Need correction.. Set sht = Application.Workbooks(Application.UserName & "." & "xlsx").Sheets(NewSh) NewSh is Sheet Name. It is also Application.UserName

Hi there, I have added the following basic code to auto hide certain tabs in a spreadsheet, based on a cell value in a specific tab (cell C30): Private Sub Worksheet_Change(ByVal Target As Range) If [C30] = "58" Then Sheets("Apr 2018 Correction Detail").Visible = True Else Sheets("Apr 2018...

I need some help in evaluating UserForm data entries. When the User clicks a cmd button, I have some code that evaluates the controls on the UserForm. When something is incorrect, I want to give the User an opportunity to make the necessary correction, and then have the code continue. Now...

Need correction in code, little correction.. Error - Object doesn't support this property or method.. With Worksheets("Sheet1") For i = 3 To RowCnt1 If .HorizontalAlignment = xlLeft Then............Getting an error on this .Cells(i, 6).Interior.Color = vbRed End If Next i...

Hi there, I am new to VBA and have used the macro recorder to record the process I am trying to achieve. The issue I am having is that when the length of the column changes my Macro is stuck to the same column length (range) I used for the original graph on the Macro Recorder. Effectively I...

I haven't created this macro and I'm a real newb with coding so I don't really know what part of this is incorrect that I keep getting error alerts Could anyone help? Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("B23:HN23")) Is Nothing Then If...

One of colleague is using the following formula, {=(SUM(('Revenue,ConMgmt,COS'!$A$2:$A$1000='2012 TOTALS'!$A46)*('Revenue,ConMgmt,COS'!$D$2:$D$1000='2012 TOTALS'!$J$23)*'Revenue,ConMgmt,COS'!$G$2:$G$1000))} I tried to change it to not using array formula and used this...

Hello, I am attempting to speed up the process by which we calculate weight percent of sulphuric acid based off specific gravity and temperature. The issue I am having is, the values given in the charts we have are not exact, therefore we have a hand-written equation that is tried-and-true...

Part 1: Ok so I am using this VBA Private Sub Copy1() Range("A4", Range("A4").End(xlDown)).Select Selection.Copy Sheets("Test Sheet 2").Select Range("A6").Select ActiveSheet.Paste Sheets("Test Sheet").Select I am trying to get data from multiple columns in the export sheet (Test Sheet) to...

A colleague created a spreadsheet which amalgomates data from 12 tabs (Each tab relates to a different date). In the amalgomated spreadsheet each cell relates to a different cell in the tabs. I dont know how she created this originally but I have noticed that in a number of the columns there is...

Hi everyone, I need some suggestions regarding my VBA code, indeed it has the purpose to copy and stick with the link my specified series. However,the multiple series are displayed (with my VBA code) such as : 1 x x x 2 x x x I would like them to be exhibited as follow : 1 2 x x x x x x...