User Profile
Imam1375
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Use Column Validation so that single text column requires an answer from a range of answers
ganeshsanap Hi Ganesh, thanks for your answer. Problem is, that it doesn't seem to work for me. The formula keeps returning #NAME? where variance driver is written. I have made sure that it is spelt exactly as it should be.Specific type of row on one worksheet to automatically appear on another worksheet
Hi everyone, Hope you're all well. I've created a workbook that is synced with a sharepoint list (via the 'Get Data' option on the ribbon). The first worksheet is brought over from the sharepoint list and contains a big list of savings or costs for each business line for each quarter for 2022 as well as the year totals for 2022, 23 and 24 etc. Alongside this, I'm planning for each business line to have its own worksheet (essentially each business line will have its own designated worksheet), where the rows for a business line, from the original worksheet, are brought over to that business line's designated worksheet, but this time there is an annual business line budget at the top of the table for each of these worksheets and a cumulative frequency column that adjusts the budget after each row of savings/costs is added. Now, I want to know, after a new row for a business line is added to the first worksheet, is there a way for it to automatically appear in that business line's designated worksheet? Thanks in advance for any help offered 🙂
