Copying and pasting mulitple formulas, can it be done?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

Can you copy and paste more than one formula at a time? In this instance I’m
referring to a work sheet has 3 IF statements; one for Monday through till
Friday is the same, while both Saturday and Sunday have different IF
statements respectively. Is there away to accomplish the copying and pasting
of all three IF statements simultaneously?

Kind regards


Tim
 
You can copy multiple cells at once. Is this what you are asking?
 
Thanks for coming back to me. I don't know what I've been thinking. The IF
statements are set up to cater for the 3 different scenarios so there is only
one column and thus one formula copied down. The confusion in my mind and set
in over the fact that I have two additional columns that deal with over time
at the weekends and have different IF statements.

Tim
 
You must log in or register to reply here.

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

Similar Threads

Copying and pasting multiple formulas, it it possible? 2
VLOOKUP & IF used with > or < 7
Rotating Work Schedule 7
Macro to copy value in field and insert it into filter 2
copy and paste all but formulas 3
Fire event code with Hyperlink and copy/paste RadioButtons 3
copy/paste row with one formula 6
Data Validation copy and paste bug 1

Back
Top