Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What formulas to use???
Hi. Please help if you can. I have a program I am trying to set up where
people have an Excel Form to enter Timecard corrections into. I want to be able to pull information from this user friendly form to put it in an order I can easily upload into my back-office application. The worksheet the users fill in has the Projects they worked on on the left side, with the week dates along the top and they would put the hours in the grid where the two meet. For each day they have any time against it, I need to pull the information from the left and the top of the grid. I was thinking I would need to do VLookup's, but don't know how to use it when the information is based on so many "if's". does somebody already have something like this created that I could use or modify to make it work for our office? Thank you, -- Dana |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |