How to an open window on 1 tab that you can editing?

hi all

i have a sauce tab with a list of all my customer with there addresses, on a separtely tab i would like to type in their account number and get all the info up ( i can do this) what i can't do is!!  i would like to be able to wright in a text box info about the customers call and have save to that customers sauce tab.

can any one help?



July 7th, 2015 11:52am

Hi RMonkey,

Based on your description, could you tell me the meaning of >>tab<<? Is this a Worksheet in Excel file?

My understanding is that you had a Worksheet 1 which contained information of customers. You wanted to create a new Worksheet 2, in Worksheet 2 you entered the customers account number. Then a text box popped up, you entered the call number into that text box, and the call number could be saved to corresponding account in Worksheet 1 automatically.

Is my understanding correct?

If yes, I suggest you try to use VBA code to get your result.

If no, please be a bit more precise to explain your requirement, so that I can provide more accurate methods to help you.

Im glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
July 8th, 2015 4:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics