david adams
asked on
Script needed to look for data and copy down page.
Hi im no expert in formulas and was given this by a work colleague who since left and thus why asking the experts :-)
Ive got the formula of
=INDEX($BA$1:$CT$1,ROWS($A
which I believe takes the data from cells BA1-CT1 and also from BA2 to CT2 and works it way down the rows on a page where I paste it. What Im trying to do is get the data starting from BA3 and copy all the way down the sheet as It is with other formula. The only thing is it will always be row 3 and just the one row. or can I add it to this formula?
Any Ideas?
Thanks
Ive got the formula of
=INDEX($BA$1:$CT$1,ROWS($A
which I believe takes the data from cells BA1-CT1 and also from BA2 to CT2 and works it way down the rows on a page where I paste it. What Im trying to do is get the data starting from BA3 and copy all the way down the sheet as It is with other formula. The only thing is it will always be row 3 and just the one row. or can I add it to this formula?
Any Ideas?
Thanks
Roy Cox
Can you attach an example workbook
ASKER
Ive sat and thought about the way Im going to do it.
I have the file called "CONTROL" and what im trying to do is to get it to open the file called summary and then go to tab called "sheet 2".
Going back to workbook called CONTROL I then need the data thats in rows 12&13 copy and pasting into sheet 2 cell B6 and the copy the formula all the way down the sheet.
Then the data thats in row 14 copy and pasting into sheet 2 cell C6 and the copy the formula all the way down the sheet.
this then needs repeating with the data in rows 17 & 18 copy and pasting into sheet 2 cell F6 and the copy the formula all the way down the sheet.
Then the data thats in row 19 copy and pasting into sheet 2 cell H6 and the copy the formula all the way down the sheet.
I think the 2 sheets explain better. When I update the file called CONTROL I need sheet 2 in workbook called summary and sheet 2
summary.xlsm
CONTROL.xlsm
I have the file called "CONTROL" and what im trying to do is to get it to open the file called summary and then go to tab called "sheet 2".
Going back to workbook called CONTROL I then need the data thats in rows 12&13 copy and pasting into sheet 2 cell B6 and the copy the formula all the way down the sheet.
Then the data thats in row 14 copy and pasting into sheet 2 cell C6 and the copy the formula all the way down the sheet.
this then needs repeating with the data in rows 17 & 18 copy and pasting into sheet 2 cell F6 and the copy the formula all the way down the sheet.
Then the data thats in row 19 copy and pasting into sheet 2 cell H6 and the copy the formula all the way down the sheet.
I think the 2 sheets explain better. When I update the file called CONTROL I need sheet 2 in workbook called summary and sheet 2
summary.xlsm
CONTROL.xlsm
I'll take a look, probably tomorrow before I can get back to you.
ASKER
yeah thats fine thanks
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.