IF function for transferring info between worksheets

  • Thread starter Thread starter milesryl
  • Start date Start date
M

milesryl

Hi,

I am trying to write an IF function to carry data from one sheet t
another if a specific word comes up. The function is being written o
a sheet that tells me who owes money 'today' and is about 40 cell
long in a column. If a person owes money 'today' then I want th
persons name, amount, and payment type to transfer over to my dail
planner worksheet. I don't know how to write the function so all th
payments for 'today' end up in the daily planner, with each payment i
a different cell.

Payment person's name is in I36=IF('[Today''s Payments o
SE.xls]Sheet1'!$D$11="DUE",'[Today''s Payments o
SE.xls]Sheet1'!$B$11,"") - This works fine.

I need the same type of function performed for cells I36:I45, which i
all under the payment person's category. and then also for K36:K4
(for payment type), and L36:L45 (for payment amount)

The cells that "DUE" is coming from is from B11:B56.

Thanks for your help
 
You can probably do this with the built in Advanced filter.

Data=>Filter=>Advanced filter. Select copy to another location and fill in
the required information.

You will need a criteria range to tell it which records to select.

See the help for details.

If you need a macro, turn on the macro recorder while you do it manually.
 
Hi Tom,

I tried using the advanced filter, but I couldn't get it to work. I'v
never used an advanced filter or a macro, could maybe explain what yo
think I should do in a bit more detail? I entered ="=DUE" into cel
D8. I used $B$12:$C$58 as my list range (merged cell), which include
my clients names. Criteria range = $D$12:$D$58. I then tried to cop
it to another worksheet because that's where I want the info to go an
an error message came up saying i can't copy it to differen
worksheets. Thanks for your hel
 
Start from your destination sheet and try it. If you get a message saying
it can't find you data, just click OK and continue on showing it where you
data and criteria are. In the destination sheet, copy the headers from
your data and then designate those as the destination.
 
Back
Top