Hi! I am new in using excel.I want to move selected data to my another excel file "database2" from "database1". But I only want to automatically transfer the data if it is mark as "approved". Is that possible?
Hi! I am new in using excel.I want to move selected data to my another excel file "database2" from "database1". But I only want to automatically transfer the data if it is mark as "approved". Is that possible?
Yes, it is. But not necesserily just with "Excel Formulas & Functions", especially if you really need automatic data transfer.
2 main options are:
- Standard macro to filter approved and move filtered data to second sheet, or
- Worksheet_Change event handler to move approved data as soon as approval column has been updated.
You can find samples of similar procedures on the forum using http://www.excelforum.com/search.php
Best Regards,
Kaper
Hi, welcome to the forum.
A macro would be able to check 'database2' for 'approved' data and automatically move it across, but the VBA experts on here would need some more detail first (which columns, etc).
Less automatically, it is possible to filter the data to show just 'approved' so that you can then copy-paste the data yourself.
In 'database1', select all the data (including header columns) then go to the 'Data' tab and select 'Filter'. You'll see little arrows appear beside each column header. Click the one in the column where you have 'approved' then select only 'approved'. This will hide all the rows which do not contain 'approved' in this column.
Now click and drag to select all the rows left visible, press Ctrl-C to copy, go to 'database2', click the top left cell of where you want the data to go and press Ctrl-V to paste - only the filtered data will be pasted.
If you want to remove this data from 'database1', you can then go back and delete those rows (or you could use Ctrl-X to cut instead of Ctrl-C to copy).
Is that of any help?
Regards,
Aardigspook
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.
Thank You for your replies.I want to automatically copy the selected data even it is not marked as "approved" in "database2" once I encoded or updated the details in "database1",
so that I don't need to "copy and paste" every time I update the "database1"
I hope this attachment will clarify my problem.
To me it looks like a quite different question than the original one. But here is the solution to post #4:
Please Login or Register to view this content.
Hi! This really solved my problem. Can this code also be used if i want to transfer the data in different excel file?
Thank You!
of course use your file name and path
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks