How to make column AD ,W ,J,,K,L dynamic in vba the data always starts at row 2.
Actually lock at row 915 , but if data goes to row 1500 or 20000 or 50
how to adjust code below
Please Login or Register to view this content.
How to make column AD ,W ,J,,K,L dynamic in vba the data always starts at row 2.
Actually lock at row 915 , but if data goes to row 1500 or 20000 or 50
how to adjust code below
Please Login or Register to view this content.
Maybe like this?
BSBPlease Login or Register to view this content.
Hello
Trying did not give me expected results .
Take same file as dummy report sheet have 195 rows and customer A sheet have 915 rows of data .
But I noticed it is taking Report Sheet to count , instead of Customer A sheet, thus having 195 rows instead of 915 rows
I think there is an issue on the lines belowPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by JEAN1972; 11-26-2018 at 01:55 PM.
Yes change
toPlease Login or Register to view this content.
May also need to change the "C" to another column if C does not always have data in every row.Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Better now thanks but a little issue on report sheet I am getting 0 up to row 911.
the 911 rows of data are found on Customer Sheet A .
Row 195 is furniture on Report sheet
I suggest you attach a sample workbook if the below code still doesn't do it... but yes I missed that the range was extended and it wasn't just the LR calculation This should help some:
Please Login or Register to view this content.
Last edited by Arkadi; 11-26-2018 at 02:39 PM.
Any particular reason you're using SUMPRODUCT over SUMIFS ? Running a few thousand SUMPRODUCTs isn't going to be particularly quick regardless.
Tried but still unsuccessful.
Attached the formula version
Please Login or Register to view this content.
Perhaps...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Sintek
Not getting expected results as below , however for column AD, the results are corrects
Please Login or Register to view this content.
Hey there Jean...Upload a sample file with expected result so guys can compare ....
JEAN1972,
Try
Please Login or Register to view this content.
Hello Sintek
as per post 8 attached sample file , should read cells y instead of w typo error.
Jindon & Xlent worked .thank you a lot
Please Login or Register to view this content.
You are welcome and thanks for the rep.
I think my cell reference was wrong...
Anyway, if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks