hi all
Please help me. i have intention to advance filter based on unique data but it can't work because blank cell. is there a macro to select only used range???
and how to sum each amount. Data is attached.
Thank you very much for your help![]()
hi all
Please help me. i have intention to advance filter based on unique data but it can't work because blank cell. is there a macro to select only used range???
and how to sum each amount. Data is attached.
Thank you very much for your help![]()
Sheets("SheetName").UsedRange
The sum bit you can use a pivot table, sumif, you can use a filter with blanks, these show as blanks in the drop down.
I'd suggest looking at how to use excel rather than macros for this and that. Macros do what Excel does, you dont need a macro for this, you just dont know how to do it in Excel.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thx sir, i try this formula but can't work
anything wrong??
Worksheet("Sheet1").Activate
Range("C:C").UsedRange
Actually ill prefer use excel but practically there are so much data in various workbook to consolidated in my workplace. every month i have new entrys so i need to reinput data. usually it takes 3 hours to finish it. so i decide to learn about macro and try to develop my report. im sorry if i wrong. im not experienced with macro.![]()
You havent done it right, Sheets("SheetName").UsedRange so sheets("Sheet1").usedrange
yes sir. this macro select all data.
what i mean is how to select used range in coloumn D after that skip all blank cell then use adv filter for unique
. as the result i have Currency that i used for next process
yes sir. this macro select all data.
what i mean is how to select used range in coloumn D after that skip all blank cell then use adv filter for unique
. as the result i have Currency that i used for next process
Sheets("SheetName").UsedRange so sheets("Sheet1").usedrange .column(4) where 4 is the column number so if your data starts at B, it would be 3.
Do some reading on the F1 help for used range etc.
thx for your help !!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks