Hoped the experts in this forum could help.
I had tried to write my 1st VBA but seems like cannot work.
I had created a form for my users to use to submit their ordering of stationery.
After they had filled up the fields, I will then copy these into a master list, in a separate file and named the worksheet as "Summary".
Option A: I do not wants to automate the copying, but uses a Command Button named "Update" and only updates when I opened this file from User A, User B, User C.
Option B: I allows user to automatically submit it to my Summary so that I don't have to open the file one by one.
Can someone help with these two scenairos?
After receiving data from all users, I will need to do a sum for the usage for the month and these data will be then put to a pivot table for easy viewing.
Read online that for the summary worksheet with VBA, it is not advisable to insert as a table. Is this true?
If yes, can I then copy the data from this worksheet Summary to another workbook call PVSum and do the monthly summary automatically? And draw lines at the same time??
Bookmarks