Calling values from another page, changing them with the new values after corrections

[turkanet]

Dear Members,

We have our all values stored in Data sheet. Sometimes we need to correct some info, then we should CALL the invoice details from Data page, and we correct. Before pasting to our Data page, we should delete old records. So, we need your kind help for below macro;

CALL: should bring all data for yellow cells from "Data" page + all data for red cells from "CON" page, depending on B11
DRAFT: should search for B11 value of New sheet in A colomn of Data sheet, and delete all rows in "Data" sheet. And then, after deleting, it must copy all yellow data in New sheet to paste to first empty cell in Data sheet. + do same thing for red cells to CON page.

Thank you

[mehmetcik]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[turkanet]

Dear Mehmet,
Thank you for your kind help. however;
Call - didnt work, did nothing when i created a module inside workbook, and ran from there.
Draft - clears row on Data sheet, but not overwrites new values. Also clears only one row in CON, and deletes values of only a colomn of the second row.
would you pls comment which part of the macros to be corrected accordingly? thank you.

[mehmetcik]

1. Call does work, unfortunately not if you use the macro name "Call". Try calling the Macro "Called" instead

2. True Draft had a couple of errors in it.

Please Login or Register  to view this content.

[turkanet]

Dear Mehmet,
i have tried just like you advised, but unfortunately both macros do not work where do i do wrong? could you check attached result file that i have added both macros? Thank you.

[mehmetcik]

Your reference number is in B11

You have no data with that reference

[turkanet]

Ok, that is correct, and when i tested with existing ref no, macros worked without any problem. but that means i have to ask your assistance for an additional case;
macro should add new values on "new" sheet to data & con if ref on B11 does not exist on data & con. Thank you really.

[turkanet]

Dear Mehmet,
Could you assist again?

[mehmetcik]

Create two new sheets, "NewCon" and "NewData" then use these macros.

Please Login or Register  to view this content.

[turkanet]

Dear Mehmet,
after changing all "data & con" pharases with "newdata & newcon" on "Called" on your last-given macro, i have below two cases;
1- "Called" brings only 2 rows from newcon. some ref has 3 rows or more.
2- When a ref is called, and made some changes on it, "Draft" does not delete old records of same ref before inputting them to "newdata". it only adds to last row.
Files last version is attached. Thank you in advance.

[turkanet]

Dear Mehmet,
Do i have a chance for your comments?

[mehmetcik]

I don't understand this:=

after changing all "data & con" pharases with "newdata & newcon" on "Called" on your last-given macro, i have below two cases;


All you had to do was to create two additional sheets.

I will look at your last sample



1- "Called" brings only 2 rows from Con. some ref has 3 rows or more.

Your sample only shows two rows of data in a block. No allowance was made for anything else.

Will all the data for a reference be in a block or could they be spread out?


2- When a ref is called, and made some changes on it, "Draft" does not delete old records of same ref before inputting them to "newdata". it only adds to last row.

By Definition, the Macro only Saves the data into NewData if the Ref cannot be found in Data.
So what would need to be deleted?

Please be aware I am going away for a week on Sunday.

Please be precise so I can finish this before I go.

[turkanet]

hi, ok;
1- "Called" brings only 2 rows from Con. some ref has 3 rows or more. => Will all the data for a reference be in a block => yes, all rows from "con" regarding same ref should be brought. sometimes a ref has 1 sometimes 10 rows in "con" sheet.
2- When a ref is called, and made some changes on it, "Draft" does not delete old records of same ref before inputting them to "newdata". it only adds to last row. => By Definition, the Macro only Saves the data into NewData if the Ref cannot be found in Data. So what would need to be deleted? => sometimes we need to amend some data. so we want to call the data by typing the ref, amend necessary info, and send them back to "data" sheet. because of values updated, when we run "draft" macro, rows of old data of same ref in "data" sheet should be deleted first, then amended new values should be written on "data".
Please be aware I am going away for a week on Sunday. Please be precise so I can finish this before I go. => thank you, this is so kind really

[mehmetcik]

Ok I have expanded "Called" as requested

Please Login or Register  to view this content.

This is the revised Draft programme

Please Login or Register  to view this content.

[turkanet]

hi,
"Called" does not bring data from "NewCon", only from "NewData"
"Darft" does not clear old values in both "NewCon" and "NewData"
Have you tried this at your PC? Could you share this file if so?

[turkanet]

Dear Mehmet,
Need your kind reply. Thank you.

[mehmetcik]

Try these

Please Login or Register  to view this content.