Welcome to Our Forums. Once you've registered and logged in, you're primed to talk football, among other topics, with the sharpest and most experienced fantasy players on the internet.
Ned I took your advice and blew up the entire workbook and redesigned it. To get around my previous problem I made drop down menus linked to drop down menus and it works great, the first menu has all the companies listed the second menu only lists the employees with each company.
I am having...
There is more to the sheet than just payroll its a daily report of work(completed and billable), equipment on site, subcontractors, inspections and employees.
My thoughts are if they can fill out one report without screwing it up I can automate the rest, but it is definitely proving a...
input sheet has a date I just did not include the top of the sheet I only posted the table I am trying to pull from.
There is that concatenate word again. I was thinking something like this
=IFERROR(INDEX('Daily Report Wed'!$E$18:$E$40,SMALL(IF($A$8='Daily Report...
Would using arrays and matching the employee name work? Obviously the employees name would need entered on the payroll sheet but then I think I could pull all the information in. Just trying to find an easy solution for construction workers who can even break locked sheets
currently is automated but not splitting out enough information for corporate.
http://s271.photobucket.com/user/knarfii/media/current_zpsskyqtopn.jpg.html
What I would like to do for each company
http://s271.photobucket.com/user/knarfii/media/proposed_zps3d23zmhh.jpg.html
http://s271.photobucket.com/user/knarfii/media/Capture_zps8hwf5kei.jpg.html
The photo is a capture of a table on my spreadsheet. I am not sure it can be done but I am going to ask anyways. We use our own employees as well as day laborers from multiple sources. Each employee may be listed...
I had the wild cards because some of our employees are not known for their accuracy so I made the sheet to find entries based on common sense things. like ford f-150 pickup, some of the guys call it a f150 truck some an f-150 pickup and some f 150 truck. I think they will just have to copy and...
I added the brackets in my example above, but on the sheet I used Cont+Shift+Enter
I figured it out I was calling the wrong sheet after the if statement. But I cant use "*"&"F"&"*"&"150"&"*" I have to use a direct cell reference like $a$183.
I have a feeling I have a syntax error. I am not grabbing any information. Table is A53 to G63, A is the equipment and column B is the cost code.
{=IFERROR(INDEX('Daily Report Wed'!$B$53:$B$63,SMALL(IF("*"&"F"&"*"&"150"&"*"=$A$53:$A$63,ROW($A$53:$A$63)-ROW($A$53)+1),1)),"")}
no the cost codes are numbers like 101-1 or 460-6-18 and they are not unique. Cars truck boats and planes may all have the same cost code for the day. I was just hoping that there was an easier way than to concatenate. I have read about how to do it I guess I'll start messing with it.
Looking for some help again.
Many months ago I needed to create a spreadsheet for work and have it grab values. I used vlookup to accomplish this task. Now I need to be able to find if my vlookup has a second, third or fourth entry and tabulate it on another sheet.
Example table...
Looking for a little assistance please.
=INDEX('Daily Report Fri'!$B23:$B33,MATCH($A$13,'Daily Report Fri'!$C$23:$C$33,0))
this line works great if there is info to find if not it returns an #NA
For some reason I can not use if(isna I get a too many arguments. I would like a blank if the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.