Hi Pete,

I'm the clerical prepartory person for new work coming into an office and
have 5 managers being assigned technical jobs (manager's id or blank if not
assigned yet is in column J). They are to complete the job without regard to
who originated it. If the job cannot be completed, then it goes back to the
originator with notes on what is missing, incomplete, etc. (S column is the
manager's id that originated the job). The rest of the fields in the
spreadsheet are filled with project data. The manager who originated the job
& the manager who was assigned the job to complete is seldom the same person.
Rather than expecting the manager to access the spreadsheet on our network
and sort their own, I'm required to hand out a paper spreadsheet twice a week
to each manager showing his open jobs (column J) and his jobs that could not
be completed (column S). I'm trying to avoid a lot of cut & paste or
printing two spreadsheets for each person. We do not have the budget for
formal training (I learn out of necessity...laugh) and cannot justify it as I
rarely create spreadsheets. Most of my training comes from the Excel Help
Menu & asking questions.

(FYI-I extract the data daily (57 columns) from an incompatible database to
a text file, import the text file into Bk1 Wrksht1, extract the columns I
need via linking to Wrksht2, apply formulas to two new columns and then
copy/paste the data & format only to Bk2 Wrksht1. Bk2 Wrksht1 is open to
viewing & sorting by all.)

Sorry if this is TMI but...you asked (chuckle)...thanks bunches,
Ruth

PS Is there any way to edit/correct my original question? I couldn't find
any moderator contact info but maybe I was looking in the wrong place. :-)


"Pete_UK" wrote:

Makes a bit more sense now. My third paragraph covers this, but if you
would like to give me the column headings in your sheet and explain
what you want to do with the data in a bit more detail, then my
comments might become less general.

Pete

Ruth_J wrote:
Pete,

Oppps!!!!!! Major typo!!!! I'm needing A1 & B1 not A1 & A2...duh!! Any
place I have A2 actually should be B1... don't know where my mind
was...sorry...long hectic week at the ofc!!

Thanks again,
Ruth

"Pete_UK" wrote:

You could do this by using a filter and manually copying the filtered
rows across to another sheet. For example, filter the column for HIRE
and only those records will be displayed. Then highlight the record(s)
you want to copy to another sheet, click <copy, select the other
sheet, move curso to the appropriate cell and <paste - only the
visible row(s) selected will be copied into this sheet.

In Ruth's case, she would have to apply a Custom filter on column A -
equal to Dog OR equal to CAT, then copy/paste as described.

Hope this helps.

Pete

twmmyv wrote:
I am also needing help on this. I have a log that I keep of new hires. I have
to log all applicants. I need for the employee info to copy over to a
different worksheet. example: if a cell has HIRE in it on tab applicant, I
need that line to copy over to new hire.

"Dave F" wrote:

To do what you're looking to do, you would have to use VBA code.

Your logic would be =IF(OR(A1="dog",A2="cat"),[copy row],[do nothing])

But as I say you can't do this if you want to stick to very basic
functions/formulas.

Dave
--
Brevity is the soul of wit.


"Ruth_J" wrote:

Hi,
Help pls... I'm only familiar with very basic functions/formulas in Excel
2003. I need to copy an entire row from one wrkbk/wrksht to another
wrkbk/wrksht based on the criteria in two individual cells in that row. (If
A1=dog or A2=cat in wrkbk1 sheet1, then copy entire row to wrkbk2 sheet1)

The original worksheet data is updated daily. Format, header, columns, etc.
never changes.

Thanks for your help,
Ruth