This is raw data of a famous accounting software called TALLY
This is raw data of a famous accounting software called TALLY
Last edited by makinmomb; 05-26-2017 at 09:52 AM.
I want a macro to do the following , populate dates on blank cells prior next date
Last edited by makinmomb; 05-26-2017 at 09:50 AM.
01/01/2016
02/01/2016
03/01/2016
Last edited by makinmomb; 05-26-2017 at 09:50 AM.
01/01/2016
fill in above date
fill in above date
fill in above date
fill in above date
fill in above date
02/01/2016
fill in above date
fill in above date
fill in above date
fill in above date
fill in above date
03/01/2016
Last edited by makinmomb; 05-26-2017 at 09:51 AM.
Then delete columns DEFG
Once this is achieved , then macro add on will continue from there
Getting those dates on the empty cells is the motto of the macro
Last edited by makinmomb; 05-26-2017 at 09:53 AM.
Manually done and created a PIVOT , find attached to get how macro will arrive
to data I have cleaned through copying dates and deleting unwanted rows
Has someone understood the question or should i re explain ?
It is only copying the dates into the blank cells
Dont know what you want to do with the "total:" line
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
humdingaling exactly what i needed , it scraps off everything I needed and populates dates wow
Part two of the macro continued
Delete all rows where column D does not have quantity , so that only inventory line items remain
Working Macro attached , someone modify that to do the added step
The logic is this , if column d has data , that row needs to remain , otherwise delete row
try this
make a copy before testing codes so you have something to refer back toPlease Login or Register to view this content.
Find attached , running your macro , it does not do the needful
makinmomb
run the code on a brand new sheet, not one that already has the dates inserted (like in the file i attached in post #15)
i have inserted comments on the code so you know exactly what is happening with it
Please Login or Register to view this content.
humdingaling , please attach file , I am not getting it correct my end , attach it when it has not trimmed the rows , so that i can save the original working macro
Thank you
i dont see no file?
Find attached , I only need those rows with no quantity to be deleted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks