April 26, 2015
As mentioned in the attached file, I have to enter details in every column whenever the client makes the payment. The details for columns F till column Q remains the same once entered. What I want is, in case the details of particular project name, particular room no and the client name have already been entered, next time when I fill the data in these three columns, it should search the data, if it matches with previously entered data, it should auto populate the corresponding figures in columns F till Q.
June 25, 2016
Give this a try.
I have added a Helper column in column E. It is for the search of the 3-column combination.
My macro was written to account for the 4 empty rows above your Table. You will need to modify the codes if you remove them.
My only concern is that you may update row 5 (for example) and the data you require to copy is below that row (row 6 and after).
The macro will then fail to copy the data as the search will only find the first matching record at row 5.
I also noticed that when new records are added below the table, not all formulas are auto copied downwards.
The codes many not be elegant but hopefully it will do what you require.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas