Search results

Hi Marc, when i activate macro rec and select from B to AF, it will give something like Range("B75:AF75").select but how if the rows add up to 85?

Hi Hui, so i have to repeat the range and formula, the problem is i have till AF :) but i think if there is no other way then i will keep repeat those, Thanks again

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

Amazing !!! thanks Marc for the support even though this kind of code is unusual from what I normally know but the result is very good and speed is very fast Thanks a lot, really appreciate it !

Hi Marc, attached result that i want, Thanks

hi Marc, this code almost do the trick if we setup the fixed range example C26:S36 then it gather all things perfectly, it is only missing the last row option and to copy the important number, can you please try to give it a go? Thanks Function RDB_Last(choice As Integer, rng As Range) ' By...

Hi, please find sample, i want to capture the important number on column B on Master.xlsm and from C26:S &LastRow from source to Master.xlsm as well put all the source into 1 folder, so that we can grab the folder path put workbook open for each source, clear background if copied large file...

Hi Marc, could you write more detail where to change from above code? Thanks

hi, i need something like below..but i want to start copy from C26 to S & LastRow (or erow in this code), is that possible? Thanks Sub copyDataFromMultipleWorkbooksIntoMaster() Dim FolderPath As String, Filepath As String, Filename As String FolderPath = “C:\work\excel_tutorial\suppliers\”...

hi Marc, could you explain to me a bit of the code? and i need the last row function when copying from source to master, Thanks

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

Thanks Chihiro, it is indeed sparkline chart :)

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 Nebu, my mistakes for that because i saw another yellow line in N so i thought we put the data there. but then when i put the data from A:H and run the macro it work perfectly thank you so much and will try to learn the code BR//Koi

Hi Nebu, thank you for trying however it is not as i put it in my example file

Hi Narayank, please find file attached Thanks for looking for the solution

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 Narayank, thanks for the suggestion, and below is get the things done from Bill Jelen

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 Gary, i sorted it out by using lastrow and add below Range("B2:B" & LastRow).SpecialCells(xlCellTypeVisible) = "Banana"

Hi Gary, when i run it against 5000 plus row it a bit stuck like for 5 minute, and maybe if i only want to type banana in the B2:B7 would it be much faster so we dont need to use the intersect range? how can we modified the macro then? Thanks

Thanks Gary, it worked like a charm Koi

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