• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    highlighter 4 consecutive

    hi , sorry didn't know . tnx
  2. A

    highlighter 4 consecutive

    hello, can someone please help me solving this? i am trying to highlight 4 cells starting with the cell that contains the word "da". i tried to make it from the conditional formating tools but it only highlight the cell that contains the cell with that text. i attached 2 pictures for a better...
  3. A

    Copy data from other sheet and sort by criteria

    waw it works great! thank you!!
  4. A

    Copy data from other sheet and sort by criteria

    thank you , the code is ok, ( i need the data to be shownd also depending on month selected in cell G2) it works well for less data, but i will have more then 100 rows with info so it will take some time to render. is there any quiqer solution with vba code? regards
  5. A

    Copy data from other sheet and sort by criteria

    Hi, I'm trying to coppy all the data from the main table (sheet "registu 1") that contain "C" letter in column I to the table from sheet "registru C" . I need these data to be showned conologically by date depending on what mounth i select (G2) The hard part is that when i change the mounth it...
  6. A

    SUM CELLS ABOVE UNTIL FIND SPECIFIC VALUE

    Hi , i want to sum all the cells above from P column until the word '"TOTAL" is find in column B. the word TOTAL will apear many times in column B but when i am writing TOTAL in column B i want to have the sum till the last TOTAL in column P Can someone please help me? thank you
  7. A

    add cell value to another cell without circular reference

    hello can someone please show me how to sum cell A1 to cel B1 in cell B1? A B A B A B 1 2 6 2 6+2 1 8+1 2 5 1 5 1+5...
  8. A

    automatly fill a given number of cells with a given value

    you are right , there werent empty spaces , there were coppying with formula the values from the other table. then can i make a vba to coppy all the values from the BE5:CF35 to AA5:BB35, and replace a number of values that are number ( ex 8 or 4) with the letter '''N". the number of values...
  9. A

    automatly fill a given number of cells with a given value

    its only a sheet , and it takes data from other 12 sheets so it's not complete. i want to fill only 10 blank spaces in each column (AA5:AA35) then (AB5:AB35) of the table AA5:BB35 whit nr 8. i will allways have more blankspaces then 10 so it wont be any error if it can't fill 10 . tanks
  10. A

    automatly fill a given number of cells with a given value

    the problem is that i can't make this work Sub LoopColumns() Dim x, i As Integer x = 1 For i = 27 To 52 Do While x <= 10 Columns(i).Rows("8:35").Find(what:="").Value = 8 x = x + 1 Loop x = 1 Next i End Sub it gives me an error when i want to run it. and after i delete Rows("8:35"), it gives...
  11. A

    automatly fill a given number of cells with a given value

    Sub Loopcells() Dim x, i As Integer, j As Integer For j = 5 To 35 x = 1 For i = 27 To 52 Do While x <= 10 Cells(i, j).Find(what:="").Value = 8 x = x + 1 Loop x = 1 Next i Next j End Sub something like this its possible?
  12. A

    automatly fill a given number of cells with a given value

    hi, i don't know why but it gives me an error 91 object variable or with block variable not set.
  13. A

    automatly fill a given number of cells with a given value

    can you change it to search blnakspaces only in that array? let's say i want to search blankspaces in the table (AA,35 ; AZ;8 ). can it be done like this? thanks
  14. A

    automatly fill a given number of cells with a given value

    Hi, I'm trying to fill automatly a certain number of cells with a given value. i want to fill the blank spaces in the table between x, c, and b , with number "8''. but i want it to fill only the first 10 blank cells from the AA row. Then the first 10 at AB , etc. Do i have to use VBA codes...
  15. A

    check if number is a date

    hope this is more clearly. Thanks
  16. A

    check if number is a date

    Hi, i want to make a code that gives the mounth and the day from two numeric cells. A1- is the day and A2 is the mounth. If A1 or A2 are not an existing calendaristic date than devide with cell A3 only the cell that itș not an existing mounth or day, if values are still not calendaristic date...
  17. A

    sum cells from column F , from value of cell C1 till value of C2

    Hi How can i sum cells from column F , depending on value from cell C1 and C2 exemple cell1 = 3 cell2 = 6 i want to sum (F3:F6) thank you
  18. A

    how to insert row based on the value from cells

    Hi How can i insert the number of rows under each cell that contains the number of rows to be added? for example in C3 i selected number 4 so it will insert 3 rows under that cell, and if possible the row inserted have unable possibility to enter datas only in column J K L M. in case after...
Back
Top