What formulas to use???

D

Dana S

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,
 
E

Eduardo

Hi Dana,
If you have an excel form already why you don't copy the information entered
in the format designed by you. As an example if you enter name, Hs, and day
in the userform, but your information needs to be day, name, Hs you can tell
that the information entered in the 3rd textbox(day) to be printed in column
A in your sheet
 
D

Dana S

Thanks for replying! The problem with that is they have one line, Project
and worked on that project for 3 hrs Monday through Thursday. That is all
one line. In my sheet, I would need to have it as 4 lines, each day a
separate line. There is no set rule on how many days they may work on a
project and my formula would need to be smart enough to know how often to
repeat the project number, based on how many days worked. Make sense?
 
E

Eduardo

Hi Dana,
Do something make a copy of the spreadsheet from the userform and paste it
in another sheet with paste special Transpose it will create the 4 lines you
need, if not please give me an example of the spreadsheet from the userform
and your spreadsheet. thank you
 
D

Dana S

Thanks! I played around with that and it will definately help me if I do it
manually. I was kinda hoping that while they enter their information into
the user friendly format, behind the scenes it would be dropping the
information in the format I need to upload.

examples are:

Primary Approver: Week Ending: 1/11/2009

Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Time Period
Week 1/5/2009 1/6/2009 1/7/2009 1/8/2009 1/9/2009 1/10/2009 1/11/2009

Programs:
08CNB21335 0.00 0.00 0.00 0.00 0.00 0.00 0.00
09NDB23335 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00


and I need it to end up like:

chgd Employee re-caclulate Project Task Acct
category Trans_date hours amount comment voucher_num voucher_line vendor
# cpnyID gl_acct gl-Sub billable text1 equip tr_id01 tr_id02 tr_id03 tr_id04 tr_id05 tr_id06 tr_id07 tr_id08 Week end date data1
chgd a 0 Labor 1/1/2009 -8 9300 y

Wish me luck, huh!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top