need a formula
I have data in a cell that forms two columns: "|sku#1 | header: data data data,header2: data2 data2 data2,header3: data3 data3 data3,header4: data4 data4 data4|" it looks like this on the webpage: header: data data data header2: data2 data2 data2 header3: data3 data3 data3 header4: data4 data4 data4 ------------------------------------------------------- to replicate this on the new webpage i need to upload it to a different server in a different format. Each header has to become a column Attribute with the data in the rows of that column | sku | header: | header:2 | header:3 | header:4 | | sku#1|data data data| data2 data2 data2 | data3 data3 data3 | data4 data4 data4 | It will look the same on the new webpage: header: data data data header2: data2 data2 data2 header3: data3 data3 data3 header4: data4 data4 data4 I have fought all night with the Microsoft formatting throwing errors so i have simplified this as much as i can. i am ok with VBA but do not understand Piviot tables so please do not suggest them. I would like a simple excel formula(s) so i can build into into my sheet but i do not think it possible even with multiple steps. i will look at everything - thanks in advance - ask questions if you need real examples or clarification. Make it so each header becomes an attribute / column header with the data below it in the column aligned with the corresponding sku
Trying to format a cell to highlight if it hasn't been checked off in 7 days.
Hi, I have a excel sheet that lists tasks as Daily, Weekly, and Monthly. I want a cell to turn yellow if it hasn't been checked off, "X", within the past 7 entries. I want the cell to change after the person has entered their initials and put "X" in all the daily tasks, to remind them to perform the weekly task. Any help would be appreciated.
Multiple unique cells copied to separate workbook
Hello, I am trying to create a macro or button that will take data or text from multiple cells (example C4,E6,G6) and copy that data to another workbook, this would not be so difficult normally however the data needs to be copied to certain areas and biased on the date (which will be in the first worksheet C5). for example C4 needs to be copied to workbook "Data arc" in the first available row in column "A" and worksheet "Jan" if the date is 1/xx/2025 or in worksheet "Feb" if the date is 2/xx/2025. E6 would need to be copied to first available row in column "M" with the same date criteria. this is a small example of what i need but if anyone can show me how to do this i should be able to figure the rest out.
Comparing work sheets in two files
I am a novice when it comes to programing and this forum. I am trying to compare two parts list to see what still needs to be ordered. File A is the parts ordered list and file B is the parts needed. Column B is the Material & column E is the Quantity Is there a way see if the material in file A:A1 match B:A1 if it does, add A:A1 to B:H1. If doesn't move on to the next device in file B until it gets a match If there no match create a worksheet that has the non-match material item with the quantity ThanksHow to have a list of Random Names
Hello, I need some help on using the function Random (not really sure if it the correct one). I have a list of process names to be reviewed by different set of personnels. Example: In column A, I have a list of 26 processes, these processes will be check by different set of personnel in a month (or 4 weeks) depending on the frequency. We only have 43 personnel that will do the checking so some names will be repeated, and some names will have only one assignment. Is there way in excel to automatically fill names every week (in random).
Field Parameter when used in filter pane not working for TOPN filters
Hi, I have created a visual as below: Now I want to filter this visual by bottom 10 worst performers Site Name by Variance parameter created. FYI the variance Field parameter table shown below: So I dragged that field parameter column into filter on this visual 'By value'. But its not showing top10 or bottom 10 instead it is showing all site name. Please advise! PFA file here Portfolio Performance - v2.15 (1) - Copy.pbix Thanks in advance Sir! SergeiBaklanCreateObject("Outlook.Application") with New Outlook
Hello, I've just noticed that when using the New Outlook, the VBA command CreateObject("Outlook.Application") generates the following error: "-2146959355 (80080005) Server execution failed". Am I the only one experiencing this issue? Or is there a need to modify the command? This works perfectly fine on the classic version of Outlook. Thank you in advance
