LinkBack URL
About LinkBacks
Book1.xlsx
Can anyone help me create macro that makes turns the before tab into the after tab?
Book1.xlsx
Can anyone help me create macro that makes turns the before tab into the after tab?
hi ajm123456789, please check attachment, option to make it, press Run
You sir are a god among men.
Any way to add conditional formating to the macro? Make each cell a different color?
can you give an example?
Book1.xlsx
Also the names in the cells?
do you mean sort of this?
Wow. I'll probably have questions later. But for now, just wow.
I extended the number of rows of data to 14 from 10. An error is occuring in the code. Can you help?
Please Login or Register to view this content.
---------- Post added at 03:34 PM ---------- Previous post was at 03:33 PM ----------
the error is in this line
vl = CLng(idata(i, n + 1))
Last edited by Cutter; 08-30-2012 at 08:25 PM. Reason: Added code tags
@ ajm123456789
Welcome to the forum.
Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.
i need file in .xls format to answer your question. If the data layout has not changed it should work
Yeah your right, there was additional information at the bottom that messed it up
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks