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

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

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

Hi All, here I am again with different question, hopefully I will get the result as always from this lovely forum, Thanks below code will do fine for sum last row from B, but how to copy it to C and D on the last row as well? Sub SumTotal() Dim Lr As Long Sheets("Test").Select Lr = Range("A"...

Hi Guru's, is there any way to copy multiple source from offline to master workbook? let say i have 100 excel file with same format in C:\\mydocument\, i want to copy from : 1. C26 : S & Last Row (last row is column C), it could be C30 or C55 as last row 2. i need to copy from D20 at the same...

Hi Master & Grandmaster, is there any way to do as attached picture? it is like sparklines but for rows. Thanks

Hi Admin, can we have like sticky post that collect all simple / good macro that we can save it as our personal macro? i can start with myself i have 2 macros in personal book. -- this is to disable page break-- Sub disablePageBreaks() ActiveSheet.DisplayPageBreaks = False End Sub -- this is...

Hi All, i need help on creating below macro, basically i can do the macro recorder for the auto filter for the date but then i got confuse on how to copy the inv2 and inv3 below the inv1 as in below example. any advice or solution will be appreciate, thanks so much.

Hi All, I'm just curious if we can combine both chart as per image below, I'm thinking of creating two stacked then no fill one of the chart to show clustered but no luck, any help will be appreciated.. Thanks

Hi All, i need help on this one, let say we have header A1 = Fruit Names and B1 = expensive then in A2 : A7 we have list of fruit let say in this order : A2: Banana A3: Mango A4: Grape A5: Banana A6: Mango A7: Pear all i want is if i put filter on A1 = Banana.. then i can fill in B2 ...

Hi All, first of all i want to explain about below macro, that macro will look for status/word "Left" in sheets "apple", "banana" and "lemon" from column B and when its found "Left" then it will do autofilter on it then it will cut & paste to sheet "Left" starting on Column B as well. it...

Hi All, i really need help on this one since i cannot make it on recorder, and through searching i found several others threat here but i cannot use it in my case. all i want is actually simple i think.. something like below :) if Sheets("sheet2").Range("A1").Value = 1 then color...

Hi there, i have this code below that works just fine by using autofilter.selection, problem is when it filter and not find the word "old", it still copy first non blank cell there. can we add like if not find "old" in auto filter then just skip to next ? thanks all for the help Sub rec()...

hi all, need some advice here on how to make a formula to pick a specific date from same date, i have 3 columns A (Date), B (Name) and C (status : success or fail), A2:A10 = date, B2:B10 = Name and C2:C10 = status all i want is example A2 : 1 jan 2014, A3:1 jan 2014 B2 : a, B3 : a C2 : fail...

Hi All, can anyone advice how to find latest date as per my example? this is basically is almost the same with find 2nd, 3rd value using lookup in chandoo example but i need to find more answer especially if not using helper column. i attached file for example and i already has the solution of...

hi all, i have a question regarding data label, lets just say we have something to be input as line chart in every week and we want to show the latest week value in the line chart, normally what i do is i select the latest dot in line chart and click add data label, then delete the previous...

Hi All, just got this problem today, i have a list from A1:A20 contain a number from 1 to 1000, but some of the number ended with ? like 10?, 109? 1? etc when i filter them and put ? in the filter its not working, and seems like ctrl+h and replace ? with blank also not working. do you have...

Hi All, I'm using excel 2013 and want to ask if we can use slicer to show top 10 or bottom 10 value filtered. thanks

hi all, i have this problem and i cannot solve it, in my pivot there are 20 countries, period (jan) and value per each country when i put the period & countries in rows, and values in values.. the subtotal of period showing me 81% avg, while when i tried to combine all value from each...