a10

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

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

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

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

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

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

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

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?

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

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

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.

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?

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

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

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

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

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

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

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

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