Recent content by koi

Hi All, I have a range of data from A3:J100, and i need the code to delete range A3:E100 (can be lastrow as well) if it find zero on column A3:A100 basically something like below, but somehow this code doesnt work, Thanks for helping me Sub DeleteRange() Dim r As Long Dim LastRow As Long...

Hi, I've managed to do it perfectly, please see below in case someone need similiar code Sub test() Dim i As Integer Dim FirstEmptyRow As Long Dim paste_range As Range Dim source_range As Range Dim LastRow As Long Dim UserInput As Long UserInput = _ InputBox("How Many Times?") 'you can...

Hi All, I need help with how to find lastrow on sheet "temp" in column A, and copy it down how many rows according to number of input text box can someone help me on this? Thanks

Hi All, nevermind the code works perfectly, only i have another sheet name "data raw" so the code also copied the data from that sheet Thanks All

Thanks All for the help, @Alan, the approach you gave me is giving me error and only add 1 sheet at the time @Fluff13, perfect solution, i can always put new name on "List" sheet A1 to A something....then run the macro, and it will create the list accordingly, meaning i can always add 10 names...

Hi All, I have 2 sheets named "list" & "template", on "list" sheet A1 is New1, A2 is New2 etc until A25 is New25 all i want is the macro to copy the whole "template sheet" and then create new sheet but rename the new sheet as as per "list" sheet A1:A25 and if I want to only create 10 sheets...

Hi Chihiro, I've done some modification by adding helper range on data sheet, so the code only 1 lines like your original one, it works perfectly no matter how many times i run the macro...the problem is the macro start on A4 line instead of A3 lines, can you give advice on how to make it...

perfect, Thanks Chihiro

Thanks Chihiro, it works well for copy and paste as value, thumbs up ! another question, what if i have another sheet name "something" but i dont want to include ...i only need from data1, data2, ...data100

Hi Chihiro, I also think about Indirect but then i have 100 sheets so I'm thinking the file could be heavy, basically I have "Summary" Sheet, where I need to make the link from A1:C1 refer to data1 sheet, and A2:C2 refer to data2 sheet till data100 example below : Summary!A1 = data1!C1...

Hi All, sorry for this newbie question but i hope someone can help me to solve it, i have link in A1 like ='Sheet1'!$G$5, what is the fastest way to copy that link in A2 for ='Sheet2'!$G$5, and in A3 = ='Sheet3'!$G$5 ? i dont mind using vba as well if normal formula wont work, Thanks

Thanks Marc, didn't read quite well that i supposed to put it in the sheet module, it works like a charm !! again thank you !

Thanks a lot Marc, but i got error code: "invalid use of Me keyword" any idea why? or probably we need to specify the sheet name?

Hi All, i need the macro to copy x lines down based on the input in helper column, and then paste transpose it to another cell. example in D2 the number is 3, then the macro will copy B2-B4 (3 lines down), then paste transpose it in E2:G2 then it search again in D2:D to find another...