a10

  1. D

    Inquiry

    Good day guys! For example i have a set of data from sheet1 from column 1 to 10 A1 0 B1 0 C1 0 D1 2 E1 34 F1 65 G1 32 H1 23 I1 15 J1 90 How can I transfer it to Sheet 2 and it will: *transfered all values to rows *it will transfer all values starting with the non zero value(in my example it...
  2. L

    VBA copy cells to another sheet

    Hi, I am wanting a code that will copy any cells within the Range of A10 to A30 that have any data in them, to another worksheet, but ignore any cells that are blank and not copy the blank cells over. I have managed to get cells to copy when i push the macro button but what I want to happen...
  3. T

    Reducing a Selection by one cell.

    Hello, Today is just one of those days that Excel just keeps beating my butt. After an hour of trying to write a simple three line code and getting nowhere I have come to the experts. The background is that I have a string in cell A10, ten blank cells (going down the column), and then a...
  4. G

    Simple formula help...

    I am not sure if it because it is Monday, but I am having trouble with a formula that I thought would be pretty easy. Here is a simplified version of what I am trying to accomplish: I have two columns (A1:B5) and a special cell A10 (ifgreater than 0). Column A is filled in manually with %...
  5. M

    Reference Column Starting At Lower Cell

    I want to reference in a cell another cells info that's in another tab. I have cell A10 that I have referencing cell W2 and copied down in each cell in column A to reference the next cell down in column W. (A11 = W3, A12 = W4, and so on) So that the cells in column A will change automatically...
  6. M

    Reference Column that Auto Changes

    I have Column A that references another column on another tab. So I have cell A10 referencing W2 on tab 2. I want column A to change automatically when Column W on tab 2 changes (i.e.- a row is deleted) and not display any errors such as #REF . I understand why it does that, but I don't know...
  7. N

    Finding last row for data starting from cell A10

    Hi Folks, I am trying to run a macro to find last row in column A and paste the value in column H:J. I am copying value from another workbook (OldWkb) and copying it in to new workbook. (NewWkb) My data starts from cell A10. I have left some space at the top to insert some pictures. Is it...
  8. A

    excel vba: if range is empty use adjacent

    Hi all, trying to finish a job involving exported data. the export populates either range A10 or A11 on each sheet with a value. what do I use to to the effect that if A10 is blank, assign the value of A11 to my variable and vice versa?
  9. T

    Indirect

    Excellers I've been doing some formulating with the indirect function for pretty much the first time. It's good. But I'm stumped as to how I can get Cell A10 in Sheet 1 to say 'Yes' if there is text populating cell A10 in any one or more of Sheet2:Sheet10 and for cell A10 in Sheet 1 to say...
  10. S

    Calculation to have cell turn red or yellow

    In cells A10 and C10, I have two different calculations with a number total for each cell. In B10, I'd like to have a calculation that looks at A10 and C10 . . . if those two numbers are the same or within 1 of each other, B10 is bright yellow. If A10 and C10 are different by more than 1, B10...
  11. J

    Multiply different cells based on the value of 1 cell

    hello, I'm trying to do the following. If cell A1 says YES then I want to multiply cell B1 and B2 If cell A1 says NO then I want to multiply cell B1 and B3 I would like the results of that formula to go in cell A10 Thanks for your help in advance.
  12. J

    Summing values from previous rows?

    Hi, Wondering best way to do this? I read about using offset but will be volatile right Example: A10: =SUM($A$2:A9) Any easier way to do this in a table?
  13. S

    Max amount within a range

    Good morning. I need help with the following, thank you. There are 2 columns: ID and rate. Some IDs are repeated, sometimes 3 times, 5 times, 9 times etc. I need to pick the highest rate for each ID and there are over 20,000 IDs. I tried DMAX but didn't seem to work. Thank you for your help...
  14. P

    VBA Hide columns based on value

    Hi Everyone I am trying to make excel hide or un-hide columns based on specific values. I have tried a few different macros, but just cant seem to get it right. What I am trying to achieve is as below: Columns in range are J:P. 1) if cell E4 = "Site 2" then column J will show, if cell E4 is...
  15. J

    Copying formulas without references changing?

    Hi, Not quite sure how to explain this... If I have a sheet with formulas that reference another sheet A2: =Data!A2 B2: =Data!B2 C2: = Data!C2 If I copy the cells to say A10 it will automatically change them to reference A10 on data sheet. Though I want A10: =Data!A3 B10: = Data!B3 C10: =...
  16. I

    What is the quick shortcut/Hot key that ive seen when applying code down the page

    Hi, As per title, I have seen a video which had no sound & wasnt clear what he had done BUT he entered a formula into say cell A10 Now he didnt grab the marker in the bottom right corner of that cell and drag to say A123 But used some kind of sortcut / hot key etc When you then looked down the...
  17. P

    Why is this "COUNTIF" formula returning 0?

    Can someone please tell me what I'm doing wrong here? =COUNTIF(Revert!F:F,Revert!C:C>EOMONTH(A10,-1)) I want to count all rows on my "Revert" sheet that are after the date in A10. So if I have the date 9/1/18 in A10, it should count all rows that have a date of 9/1 to the present day. Edit:I...
  18. M

    Data arrangement macro

    I want to re arrange my data as follows , if i do manually it will take long , cell reference A meaning on sheet 2 <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> D3 TO A1 E3 TO A2 J3 TO A3 O3 TO A4 N3 TO A5 F3 TO...
  19. A

    Combobox fill data = rngFind.Offset

    <colgroup><col span="2"></colgroup><tbody> column Z column AA A A01 B A02 C A03 D A04 A05 A06 A07 A08 A09 A10 B01 B02 B03 B04 B05 B06 B07 B08 B09 B10 C1 C2 C3 C4 C5 D1 D2 D3 D4 D5 </tbody> Good Day, Column Z...
  20. D

    Run MS Dos Command CMD any copy text from Excel cells...help please?

    Hi, I am almost there but struggling with the last part - I have a command line in an Excel workbook (SHEET1 cells A1 to A10) - I would like to have a macro to open cmd (command in MS DOS) and then copy the text in cells A1 to A10 to the command (CMD) line. So far I have Shell "cmd.exe /k...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top