Hello,
I am filling data throughout a column, with these formulas:
Cell B1067 -> =IF('Sheet2'!$D$21>0,'Sheet2'!$D$21,"")
Cell B1068 -> =IF(Sheet2'!$O$21>0,'Sheet2'!$O$21,"")
Cell B1069 -> =IF('Sheet2'!$D$21>0,1,"")
etc.
I have different formulas for cells B1067 to B1073 (7 cells) that I would like to repeat, but then refer to a different row. (Next set refers to row 22, then row 23, and so on). How can I fill the cells to repeat the pattern, referring to the following row each time?
Thank you!
So the formulas for B1067 through B1073 are all different and then you want them to repeat? i.e. B1074 will be exactly like B1067?
=IF(Sheet2!$D$21>0, Sheet2!$D$21,"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It will repeat but refer to the next row.
=IF('Sheet2'!$D$22>0,'USR SOV'!$D$22,"")
Right now I'm copying them and updating the cell reference manually, but it is a very tedious process..
Suggest you upload a sample workbook, showing what you have (cleaned) and what you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Okay, I think I can do this but would need to know what are the 7 formulas in B1067 -B1073?
Here's what I would do, come up with formulas that will work if copied every 7 rows, then name those formulas, then put those named formulas into B1067-73, then select and drag.
Please upload a workbook with sample data for working out the formulas.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Sample.xls
Here is the spreadsheet I'm working with. I am using [Sheet 1] to fill a PDF, so there is a lot of data. I have highlighted the cells I'm currently working with in yellow. Cells [B1067:B1073] and [B1074:B1080] reflect the pattern that I am needing continued throughout the highlighted cells.
Thanks for the help!
Last edited by imagineissac; 05-14-2014 at 10:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks