Hi, I have a spreadsheet which is for Sales Invoice Template. Its link to another tab call Data. I wish to be able to have a "update" function.
Please see sample excel for details. Thanks!!!!
Hi, I have a spreadsheet which is for Sales Invoice Template. Its link to another tab call Data. I wish to be able to have a "update" function.
Please see sample excel for details. Thanks!!!!
Possible with VBA. See attached for one quickly thrown together method of doing this.
Essentially what it does is update the details on the second sheet to reflect changes made on the first sheet, then adds the VLOOKUPs again.
BSB
I am a little confused by your request. Do you wish to amend existing records in the Data tab or create new records in the data tab. These are two different functionalities which would need to be addressed.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi, Badlyspelledbouy, your vba work but only when the customer appear only 1 time in the Data Tab. I tried to "update" other invoice, if the customer name appear more than 1 time, it will automatically update the most bottom data.
Hi, Alansidman, the "Sales" tab is actually where viewer can see the details. I have created another easily sample. The previous one is Column to Row which i think should be more troublesome. Actually, all i wan it to do is Copy and Paste the Row to its respective Row in Tab Data.
You have not responded to my question. Are you updating the existing records or creating new ones. Your explanation of your situation does not elaborate on this.
Hi, BadlySpelledBuoy, your VBA work, sorry.... However, the problem is, my excel actually has a lot of fills. Maybe 50. I will take a long time to do like how u do, especially when i am not so good at VBA. Hence i am thinking of Copy and Paste (Please see my Sample question 2). I think it should be easilier right??
Hi, Alansidman, its actually Viewing and Updating, not creating new entry.
I don't see how that approach would be easier. It's adding an extra element that is unnecessary.
If you mean you have lots more fields that would need pasting then you could use TRANSPOSE and negate the need for the hidden row 1.
BSB
Hi. Anyone can help? Need it urgently.
Perhaps if you could explain what is wrong with the solution provided already I would be easier for someone to help.
BSB
Hi. Because my "sales" tab is actually in horizontal. Not vertical. In sales tab, row 1 is actually the header, hence, sales invoice is at A2, date at B2, customer name C3, qty at D2 while amount is at E2. Hence actually all i need is to find the sales invoice in A2 and select the entire row and just copy to the respective Data tab row. I only realise its horizontal format after you send me the first solution. Hence i do up another sample. I'm afraid you will get **** off if i confess my first sample is wrong.... Sorry... But please help...
Hi, BadlyspellBouy, please refer to the Excel. I want user to be able to Manually change the value at the Sales Tab. Then upon clicking on a button, the whole thing is copy and paste in the recpective row in the Data Tab. However, I wish to Retain the Vlookup formula in Sales Tab.
Hopefully this will suit your needs.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks