correction

  1. H

    Copy to next blank column - almost there

    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?
  2. B

    Pivot table not updating - VBA

    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...
  3. Vincent Thank You

    Excel Correcting Max Formula

    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...
  4. M

    Need Help with VBA Code

    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...
  5. B

    Help in correcting excel formula

    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'...
  6. V

    Column A Disappeared; Not Hidden

    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...
  7. A

    Correction require

    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
  8. V

    Need Code edit - 3

    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
  9. N

    Hiding tab code not recognizing number generated from Active X control

    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...
  10. R

    UserForm Data Correction and Input Boxes

    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...
  11. V

    Need correction in code, little correction..

    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...
  12. M

    VBA help for auto creating Graphs. Current Code included

    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...
  13. D

    what is wrong with this macro? keep getting error alerts popping up

    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...
  14. srizki

    Please Correct the Formula,

    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...
  15. T

    How does one enter in two variables, both of which have to corrected, to get an answer?

    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...
  16. S

    Sorting Data Question 2 Part

    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...
  17. H

    Changing a formulae multiple times in excel

    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...
  18. E

    VBA code : suggestion

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top