LinkBack URL
About LinkBacks
Hi there.
I'm new here, so thank you for accepting me.
I hava a workbook with 2 sheets. The 1st sheet "Local Process" gets data from a data base in access. The 2nd sheet "Global Process" is the global list of all the proccess ordered.
So, when access send new data, the sheet 1 is fielded with that data, no mather what the number of the local process. What i need is when i have this new data, the sheet 2 is updated.
I give a example (i'll try)
Sheet 1
Local Process Name Address Phone Local
1/CTT/2015 Alice USA 1234 A
3/CTT/2015 John USA 3214 A
9/CTT/2015 Tom USA 4567 B
Sheet 2
Out Number Global Process Name Address Phone Local
(Manualy insert) 1/CTT/2015 Alice USA 1234 A
1/CTT/2015 John USA 3214 A
2/CTT/2015 Tom USA 4567 B
Because the 2nd sheet, the Global number is based in the "Local". If the "Local" is the same in the next row, the "Global number" is gonna be the same.
I have a formula in the "Global number" to do this. And i have also a hidden column called "SubDivision" between column B and C, to set the same "Local".
My problem:
When sheet 1 gets new data, this new data is gonna update sheet 1 (if i have 3 records, start in the record n.º 4) and then update sheet 2, to continue the Global Process number (If have 3 records, star in the 4º)
Is there a way to automatize this?
Thank you and sorry for my bad english.
Regards,
B.
Register To Reply
Bookmarks