Register
Log In
Unanswered
Home
New Member
April 26, 2015
Offline
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.
Thanks.
Rakesh
Dashboards
June 25, 2016
Offline
Hi Rakesh
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 Online: clark shao, Max Neumann
12 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
