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