Many thanks to Pete for helping me with this! And Ford for the advice for getting me started!
Many thanks to Pete for helping me with this! And Ford for the advice for getting me started!
Last edited by print85; 05-06-2018 at 07:11 AM.
Hi, welcome to the forum
To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
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
Hi Ford,
Thanks for the help. Hopefully a dummy version is now attached.
There's not a lot of data to work with, but you can use this formula in D2 of Sheet1:
=IF(B2="","-",B2&"_"&COUNTIF(B$2:B2,B2))
Copy this down as far as you like, in order to accommodate more data being added - the hyphens will show where the formula is active.
Then, assuming your TeamA sheet is typical of other subsidiary sheets, with the sheet name in cell E1, you can have this formula in cell A2:
=IFERROR(INDEX(Sheet1!A:A,MATCH($E$1&"_"&ROWS($1:1),Sheet1!$D:$D,0)),"")
You may need to format this as a date in the style you prefer, then copy this into B2:C2. Then you can copy the formulae in A2:C2 down as far as you need to.
If you need other sheets like this, just copy the TeamA sheet (using Ctrl-drag of the sheet tab), then rename the sheet and change the sheet name in cell E1.
Hope this helps.
Pete
Hi Pete,
Thank you SO much, that works exactly as I was hoping and having been looking to do!
Have attached the file with the formulas in case it's helpful to anyone else too.
Thanks again.
Same concept, but different workbooks... Can this be done?
Example:
I have a CAPA log, my manager wants to pull out only the SCAR's off the log to populate a different work book so he can capture the yields.
The current CAPA log captures Internal, External, and SCAR's.
Any help would be great,
Liz
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks