Search results

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

Hi All, I need help again for the error that i'm getting in the macro, everytime it happened i need to click on the yellow arrow and move up a bit, then click on continue so that the macro will run, and after it run..the error wont happen again. question is why it is happen on the first time...

Hi All, I need help on insert several pdf file into several excel file, can it be done by using names? i have excel files naming as : 1.xlsm, 2.xlsm, 3.xlsm, and i want to insert 1.pdf into 1.xlsm in the sheet1, 2.pdf into 2.xlsm in the sheet1 and 3.pdf into 3.xlsm can it be done like that...

Hi Luke, if now i want to find the similiar things between A & B, with the sample above, can it also be done? Thanks

Hi Luke, Amazing Job, you got it first time right, thanks a lot for helping me ! koi

Hi All, hope you are all good and well, I have this most difficult task that i cannot solve, hope that you have the answer for it. example 1: in column A i have : I.like.eat.sushi in column B i have : like.meat in column C i would want it to say : I.eat.sushi example 2: in column A i have ...

worked like a charm!, cannot thank you enouh Chihiro !! THANKS

Hi Chihiro, i can tell that it is working, size of the excel file is changes.. but when i open the file, excel is open but the content is grey, what could possibly go wrong here? Thanks

Hi Chihiro, i agree with that, it can be open, write, save and closed without even appear

Hi All, just want to ask if it is possible to write several closed workbook, from an open source i.e i have 3 closed WB named as book1, book2 and book3 i have open excel file with 3 things from A1 to A3 that i need to write it to book1 A1:A3. then from open source B1:B3 need to write it to...

Thanks All for the helping, Hui solution work best although Narayank second one also works, regards, Koi

Hi Marc, can you give some more pointer? or example since all i've done with the recorder cannot give me dynamic rows if i adding more rows