0
Hi i am not familiar with VBA code but i know java. I am looking to create a macro that checks if a cell is not blank and autofill the cells in another column but in the same row with the formula above them. Any ideas??
975 805040 2065bc210 325647998522
976 802030 2089bc212 325647956721
977 *325647964751*
978 *325647967866*
979 *325647964452*
Sorry for the lack of details. This is an example of my excel the left are the numbers of rows i need to autofill the other collumns when i add manually the numbers in stars. The other columns get their information from a formula. I cann't post a pic because my reputation is low.
Something like that but didn't worked
Sub CheckCell()
Dim i As Integer
i = 3
Do
Selection.AutoFill Destination:=Range("Ai:A(i+1)"), Type:=xlFillDefault
i = i+1
Loop While (ActiveSheet.Range("Bi").Value != "")
End Sub
i did that but the check is not recorded because i do it visual.I want the macro to autofill the other columns like i do with draging-aytofill until the last row of the cells that i added – rexxar – 2013-03-20T14:02:55.940
Please [edit] your question with more details about how the data is laid out and what the "autofill" source data is. What does "in the same row with the formula above them" mean? You say VBA and formula in the same question. Which do you want to use? – CharlieRB – 2013-03-20T14:33:02.057