Hi,
I have below data with me where i need a vba to perform the following activity
Current data
Line Amount tax Code Tax rec rate
-175.26 VA-19 19
Required Data
Line Amount tax Code Tax rec rate
-175.26
-33.30 VA-19 19
This needs to be filled till last row
rgds
rk
Last edited by rkpg; 06-07-2018 at 03:43 AM.
rkpg,
better to upload a sample workbook with current data and and a sheet with data you'd like to have.
Beware to not put sensitive data into you workbook!!
Also tell us how the new data should be converted.
Where does the 33.30 come from? Is this a fixed value to add to the current data?
Even a little help can be a big help !!
1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
4. Use [CODE] [/CODE] tags to illustrate your code: see here
Refer attached sample file with non sensitive data...tax rate (column P) is taken from the Column O.
rkpg,
this should do the trick
I included your book with the code.
Please Login or Register to view this content.
Run the macro on the page with menu "View - Macro's" - select view macro's.
Select SplitRows and run it
it worked...thank you so much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks