Dear All
I attache a file and do what I want manually in my file I appreciated if you show me how I can do it by VB not manually
my database is very long with more than 20 parameters so I need a code for do my job
thanks
Dear All
I attache a file and do what I want manually in my file I appreciated if you show me how I can do it by VB not manually
my database is very long with more than 20 parameters so I need a code for do my job
thanks
Last edited by pedjvak; 08-26-2013 at 04:53 AM.
Your worksheet has designed upside down so I copy it to appear in normal way as sheet2.
Last edited by AB33; 08-26-2013 at 04:03 AM.
Dear AB33
thanks for your answering
but in sheet2 when I add new record (Date & Name & loading ) and run your macro unfortunatly it dosen't happen
Last edited by pedjvak; 08-26-2013 at 04:23 AM.
No, unless the format of the sheet has changed. Row 3 should remain the same and the sheet name is "Sheet2", but you can add any row to columns H and A and the code should work. I also use current region, if there is a gap, i.e. a complete blank row, the code will not pick up all the rows.
thanks you right
it is working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks