Copy formula to all worksheets
Good day!
For all worksheets in the activeworkbook,
i want to automatically copy a formula (=INDEX(KEBSIDF20080925_26!$A$3:$A$10000,MATCH(A4,KEBSIDF20080925_26!$A$3:$A$10000,),1)
to a target cell (D4). Each worksheet has the same headers.
Thanks and best regards.
Last edited by RAparente; 12-12-2008 at 03:19 AM.
Hi
How about
ryloFor i = 1 To Sheets.Count Sheets(i).Range("D4").Formula = "=INDEX(KEBSIDF20080925_26!$A$3:$A$10000,MATCH(A4,KEBSIDF20080925_26!$A$3:$A$10000,),1)" Next i
Solved
thanks! it works.Originally Posted by rylo
You should know, you can type a formula into all the worksheets at the same time.
Click on the first Sheet-tab. Shift-click on the last sheet-tab in the range, they should all be selected now. Click on the cell on the visible sheet and enter your formula. When you press ENTER, the same formula is entered on the same cell in all highlighted sheets.
FYI. No macro(s) needed.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi. Yeah, great. thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks