2d
|
comment |
Checking and Pasting Data from another sheet using VBA It's not clear which cells are merged. Please provide that detail. |
|
Jul
18 |
answered | How to fill Excel formula up dynamically, in upper direction? | |
Jul
18 |
comment |
How to display value retrieved from column CMDB @KenWhite Not sure what the issue is. I've been posting that comment to my answers for at least ten years without any issue. I only post this comment if the OP is a brand new user and may not yet have seen the tour. I'm not "begging" for an answer. I am inviting them to feed back if the answer doesn't meet their needs and I'm giving them the information to accept the answer as described in the tour. What's wrong with that? Nobody has ever given me negative feedback on that. Until you today. |
|
Jul
18 |
answered | How to display value retrieved from column CMDB | |
Jul
18 |
comment |
Copy values (Not formula) in one row from multiple worksheets onto summary worksheet in same workbook Next to the name Debra, you type a = and then click to the Debra sheet and select the cell you need. Rinse and repeat for the other names. As I understand it, your summary sheet lists all drivers, so you just type their names and manually pick the cells for their data. |
|
Jul
17 |
comment |
Checking and Pasting Data from another sheet using VBA If that resolved your issue, please mark the answer as described in the [tour]. If it didn't, please leave a comment, so I can follow up. |
|
Jul
17 |
answered | Checking and Pasting Data from another sheet using VBA | |
Jul
17 |
revised |
Match cell value in a specific cell across multiple sheets and return another cell value from the sheet with a match added 607 characters in body |
|
Jul
17 |
comment |
Match cell value in a specific cell across multiple sheets and return another cell value from the sheet with a match If that resolved your issue, please mark the answer as described in the [tour]. If it didn't, please leave a comment, so I can follow up. |
|
Jul
17 |
answered | Match cell value in a specific cell across multiple sheets and return another cell value from the sheet with a match | |
Jul
17 |
revised |
In excel I want to write a formula that when a number is presented its translated to text deleted 81 characters in body |
|
Jul
17 |
comment |
In excel I want to write a formula that when a number is presented its translated to text .... and when the thresholds change, or they insert a new grading category, all formulas need to be adjusted. That is not necessary if you use an efficient lookup formula. |
|
Jul
17 |
comment |
In excel I want to write a formula that when a number is presented its translated to text If that resolved your issue, please mark the answer as described in the [tour]. If it didn't, please leave a comment, so I can follow up. |
|
Jul
17 |
comment |
In excel I want to write a formula that when a number is presented its translated to text Jeeperz, could you make this any more convoluted? The same result can be achieved with a simple Vlookup function. |
|
Jul
17 |
answered | In excel I want to write a formula that when a number is presented its translated to text | |
Jul
17 |
revised |
In excel I want to write a formula that when a number is presented its translated to text added 70 characters in body |
|
Jul
17 |
comment |
Copy values (Not formula) in one row from multiple worksheets onto summary worksheet in same workbook Why do you want to do this with VBA? You could easily write a formula that sums the data or references a cell with a total from the driver sheets. |
|
Jul
17 |
comment |
Excel VBA button This site is not a free code writing service. There are many examples on the internet that are only a search away. |
|
Jul
17 |
comment |
In excel I want to write a formula that when a number is presented its translated to text Any lookup function, really. Vlookup, Xlookup, Index/Match. IFS() should be a last resort. It's possible but not very scalable. @nkalvi |
|
Jul
17 |
comment |
Is there a way to refresh Power BI snapshot inserted in a Power Point Presentation automatically? Seems to me a wrong use of Power BI. Instead of sending a PowerPoint with screenshots of the Power BI charts, publish the Power BI report or a dashboard to the intended audience and let them access the info directly. That's what Power BI was invented for. |