Creating a Form That keeps Its Properties While Pulling from database

[joeynice]

HI,

Totally new to this forum thing, so excuse me if I ask questions where I am not supposed to or even questions that should have pretty simple answers.

I am trying to create a form for us to use to track our subcontractors at each of our jobs because we are ha I want to set it up so that it is an identical form that populates information from from a database.

Here is the basic concept.

I want to auto populate the info so that all of my supervisors can just put in the amount of days worked as well as the added services and deductions because those are never the same number or formula.
I want to pull from the database the name of the client, all of the info for the client as far as what we pay on their contract, the SUB name that is contracted through us, create his formula for pay etc etc

I am able to do this just fine no problem for 1 (one), but as i start trying to copy and paste what i did to the next client, it goes all haywire.

does anyone have ANY advice?

Please and thank you

J. Nice

P.S. I have attached an example worksheet to show what i am trying to do.TEMPLATE-payroll.xlsx

[FDibbins]

Hi and welcome to the forum

If you could get to the point where all your headings on each sheet match exactly, we could probably use index/patch to get the data based on then Client Name. For instance, this will pull out the AA for you...
=INDEX(Sheet4!$A$1:$BF$14,5,MATCH(PAYROLL!$C$2,Sheet4!$A$1:$BF$1,0))

Now, if we had the same "headings" on each sheet, we could use another MATCH() to determine the row, instead of having to use 5.

Take another look at your tables and see if you can come up with matching names that will still work for you, then post back and wqe can take the next steps

[joeynice]

Hi,

Thank you for your response. I redid the way my headings were, and simplified. I made it is so that i can be better understood what i am trying to do.

Please let me know what you think, and thank you for your help.

[FDibbins]

That makes things a LOT easier I think the data in D should be in C though? Based on that assumtion, and having the "heading" on the left and the data on the right, try this...

1. In C2, copied down, use this to pull out the "customer" (you can set this to grey font on grey background if you want to hide it...
=IF(C1="",C2,B1)

Then in all the all the cells you need to pull in data, use this, copied down and across...
=IFERROR(INDEX('Customer INFO'!$B$1:$O$3,MATCH($B3,'Customer INFO'!$B$1:$B$3,0),MATCH(C3,'Customer INFO'!$B$1:$O$1,0)),"")

[joeynice]

Ok so I switch the data from D to C on the PAYROLL Page, but then I have to admit that I lose you. What do you mean in C2 copied down? Where do i enter the formula? I am sorry if I am so novice at this.