Can this formula be placed in VBA please.
Thankyou.
"Dave F" wrote:
Copying this formula down 700 rows shouldn't be that time consuming.
Here's a way to do it quickly.
1) Copy and paste the formula into the top cell of the column you're copying
the formula to (say E1).
2) Go to cell A1 and hit CTRL + down arrow. You should be at the bottom of
your data (row 700).
3) Navigate to cell E701 and enter a period.
4) Hit ctrl+ up arrow. You should now be at E1.
5) Select E1, then SHIFT + CTRL + DOWN ARROW
6) CTRL +D
7) Hit enter to calculate.
Practice and this should take all of 5 seconds. You could also record all
these steps in a macro and assign it to a button.
"Steved" wrote:
Hello from Steved
=IF(ISNUMBER(MATCH(--B2,Staff!$A$2:$A$2000,0)),VLOOKUP(--B2,Staff!$A$2:$C$2000,2,0)&CHAR(10)&VLOOKUP(--B2,Staff!$A$2:$C$2000,3,0),"")
Every day I have to copy the above formula to a new worksheet ( 700 Rows )
If the above is possible I will use the same worksheet every day, just
updating the previous day Worksheet, hence I will nolonger have to input the
formula..
Thankyou.
|