LinkBack URL
About LinkBacks
i need your help bro !
can anyone modify it to Move the Selected Data to another Existing WorkBook “Database.xls” sheet1 which already exist in MY documents, if the Database.xls is active ? or not…
Please Login or Register to view this content.
i need your help bro !
can anyone modify it to Move the Selected Data to another Existing WorkBook “Database.xls” sheet1 which already exist in MY documents, if the Database.xls is active ? or not…Please Login or Register to view this content.
Last edited by xcruc1at3r; 08-09-2011 at 07:05 PM.
I'd be glad to tackle this, but forum rules are that you MUST enclose your code in code brackets so it will display properly.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
how will i do that ~!~>>? i dont know how to do that my friend am new in this town... .... Found itthe code option rite :D
Last edited by xcruc1at3r; 08-08-2011 at 09:03 PM.
NOTE: This has not been tested. To do that, I need a sample of your workbooks.Please Login or Register to view this content.
well i have attached the ITV Report.xls its a sample from my main report and i want to move the data that i select in the genset sheet as u know that we select range with a mouse as well so that should move to the active worksheet DATABASE.xls Sheet 1 (complete-database) only the selected do add the option of multiple selection pls
The Database.xls will have all the same cell names as in the ITV Report.xls
the difference is that ITV report is based on daily updates and Database.xls will be for all the activities
Sample-ITV Report.xls
this is the Sample of database.xls my main report is of 6mb that why i didnt sent u the complete report only the sample so u can understand the scenarioITV-DATABASE.xls
Do you want to copy just the selected cells, or all the data to the left and right of the selection as well?
bro i have to get read n leave for office so see ya soon man!
and thanks a million for helping me out
only the selected data ! should move to the 1st available empty row
Last edited by xcruc1at3r; 08-08-2011 at 10:33 PM.
It sounds to me like you want to allow selections of multiple, not necessarily sequential records, copy those, and paste them in the first available row in the Database.xls workbook. This code, slightly modified from what I posted above, will do this. Note that it requires the Database.xls workbook to be open. Run the code from the ITV-Database.xls workbook.
Just place the above code in a code module in your ITV-Database.xls workbook.Please Login or Register to view this content.
Let me know if this does the trick for you.
BRo U ROCK MAN....Big Time
AwsOmeeeee....
Well I really Want to learn how to create VBA macro's can U Guide me ! how to start... e books and site addresses so i can help Out PPL like U do...and assist U as well...
Thanks for your kind words! You might invest in the Excel 2010 Bible available through amazon.com. I'd also run a search on VBA. I don't own any references and am mostly self taught, so I can't vouch for how good any of it is.
Could you consider marking your post solved?
Thanks!
Tom
THis Thread IS SOLVED PPL thanks TO "tlafferty"
Last edited by xcruc1at3r; 08-09-2011 at 07:06 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks