Search results

i think you are not Adjusting column names as needed based on your actual data structure. If you encounter any issues or errors, please let me know the specific error message so I can provide further assistance Here is what you have provided

Replace this part of the code: // Merge the table with itself to get the cumulative sum of Actual MergedTable = Table.Join(AddIndex, {"Activity", "Company"}, AddIndex, {"Activity", "Company"}), // Filter rows to include only those where the index is less than or equal to the current...

Let me check

Here's the revised Power Query code: let // Assuming your data is loaded into a table named "YourTable" Source = YourTable, // Add an index column to keep track of rows AddIndex = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type), // Merge the table with itself to...

Check modified query! let // Assuming your data is loaded into a table named "YourTable" Source = YourTable, // Add an index column to keep track of rows AddIndex = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type), // Merge the table with itself to get the...

I really appreciate, if you let me know the error/issue you are encouraging while using the code...Give more details

Adjusted based on sample dataset you have provided let // Assuming your data is loaded into a table named "YourTable" Source = YourTable, // Add a custom column for remaining planned value AddRemainingPlanned = Table.AddColumn(Source, "RemainingPlanned", each [PlanY] -...

Dis you try provided M code

You can try this let // Assuming your data is loaded into a table named "YourTable" Source = YourTable, // Add a custom column for remaining planned value AddRemainingPlanned = Table.AddColumn(Source, "RemainingPlanned", each [Planned] -...

Hello...I have issue in opening the file..I appreciate if you can explain the structure to help you or you can try the formula provided by changing ranges accordingly.

You can try this! Sub PrintSheets() Dim wsInput As Worksheet Dim i As Integer ' Assuming input data is in the first sheet Set wsInput = ThisWorkbook.Sheets(1) ' Loop through sheets 2 to 14 and print them For i = 2 To 14 ' Copy input data to the current...

Hello Binas What i can think of this to achive this in Excel, you can use Power Query to transform your data. Here's a simplified step-by-step guide: 1. Load your data into Power Query. 2. Create a custom column that calculates the remaining planned value for each month. 3. Use a conditional...

Try this! =IFERROR(IF(ROWS($2:2) <= COUNT('Appollo For Natural Oils'!$A$249:$A$777), INDEX('Appollo For Natural Oils'!$A$249:$A$777, AGGREGATE(15, 6, ROW($A$249:$A$777)/(MATCH('Appollo For Natural Oils'!$A$249:$A$777&'Appollo For Natural Oils'!$D$249:$D$777, 'Appollo For...

Hello Hany Add two dates in Google Sheets using cells G1 and H1 and use the resulting date =IFERROR(INDEX('Appollo For Natural Oils'!$A$249:$A$777, AGGREGATE(15, 6, ROW($A$1:$A$7166)/(MATCH('Appollo For Natural Oils'!$A$249:$A$777&'Appollo For Natural Oils'!$D$249:$D$777, 'Appollo For Natural...

Hello, Can i have more information

Fanatic, Thanks for sharing!

Hello KreshBell As per my knowledge, you cannot directly share an XLSB file using a share location like you would with a regular document or image. XLSB files are binary workbook files used by Microsoft Excel, and sharing typically involves sending the file through email or a cloud storage...

While I can't provide direct downloads as am not sure but yyou can find various project management templates on platforms like Microsoft Excel, Google Sheets, or project management tools like Asana, Trello, or Jira. Look for templates specifically designed for tracking team objectives and...

Hello Anurag As Pecoflyer suggested,Forums usually don't provide help for breaking passwords... But i may suggest to go through this video may helpfull in case if you have forgetten and struggling to get the password back without any software

I did some tweek...lets see Sub RunMacrosBasedOnTable() Dim ws As Worksheet Dim cellValue As Variant Dim i As Integer ' Set the worksheet where your table is located Set ws = ThisWorkbook.Sheets("OD_POS") ' Change "Sheet1" to your actual sheet name ' Assuming your...

Modified code Sub RunMacrosBasedOnTable() Dim ws As Worksheet Dim cellValue As Variant Dim i As Integer ' Set the worksheet where your table is located Set ws = ThisWorkbook.Sheets("OD_POS") ' Change "Sheet1" to your actual sheet name ' Assuming your table starts from...

Check this and let me know Sub RunMacrosBasedOnTable() Dim ws As Worksheet Dim cellValue As Variant Dim i As Integer ' Set the worksheet where your table is located Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your actual sheet name ' Assuming your table...

Hello Shan Please find below code as pwr yiur requirement. Sub RunMacrosBasedOnTable() Dim ws As Worksheet Dim cellValue As Variant Dim i As Integer ' Set the worksheet where your table is located Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your actual...

I understand your frustration in general. In that case, you might want to consider uninstalling and reinstalling Excel, ensuring you have the latest updates. Additionally, double-check if there are any conflicting settings in your system or if other Office applications are behaving similarly. If...

It sounds like you might be experiencing a formatting issue in Excel. Try these steps to set the default font: 1. Open Excel and go to the "File" tab. 2. Select "Options" at the bottom of the menu. 3. In the Excel Options dialog box, go to the "General" category. 4. Find the section labeled...