Hi
If I click on Share Worksheet then Protect workbook/sheet will be grayed out. so I should first pportoct workbook/sheet firs then share. What is the idea behind this sequence.? Thank you very much
Ok,
This not so easy in my case. I have a shared file with shapes on multi monitor for each working position as a share file. To edit shapes you have to un-share the file, that I do in code and re-share in code when complete (10-30sec).
My problem is the when on share I lose the...
I am looking for a formula for "Weighted Share Based on Ranking". Any help would be appreciated. Thanks!
<tbody>
Doctor
Ranking
Weighted Share Based on Ranking
Smith
1
1.05
Jones
2
1
Johnson
3
.95
</tbody>
Dear All,
In my Col A, I have fixed words, which I want to make them in small letters only.
words are,
Col A contains statements, any statements wherein, the above words are there...and they should remain in small letter...
Pls share the code...
Dear All,
I hope you can help me I am trying to download historical share data for share 8088 from yahoo Japan.
The first page of the table I need is in the following location: - https://info.finance.yahoo.co.jp/history/?code=8088.T&sy=1983&sm=11&sd=19&ey=2017&em=12&ed=19&tm=d&p=1
I then...
Hi,
I've been struggling with this for a while, but I am trying to do a Opportunity Gap calculation within the pivot table.
Below is how i have my data laid out. I am able to calculate $% Change, Retailer's Share (TY/LY) and the Share Point Change all within the Calculated Field portion. But...
Excel will not let me share a workbook with a table that has been created. To share it I need to convert the table to a range, this reduced the functionality of my worksheet. I have to share the workbook so that I can track changes. I need to see a history of various values that have been...
Hello all, actually im from excel forum and im post this problem but no response..
my problem is i have a two excel file with a userform connect each other and i want the one excel file to use in other computer. i try share workbook and folder shared but same failed. how to use my excel in a...
<tbody>
A
B
C
Week 1
Week 2
MFG A
MFG B
MFG C
MFG A
MFG B
MFG C
MFG A
MFG B
MFG C
Bananas
.6
.2
.2
ON
Apples
.1
.4
.5
ON
Oranges
.3
.5
.2
ON
</tbody>
Columns A,B and C represent Percentage of Unit Volume by MFG for the Fruits to the left.
Using...
Hello,
I want to know if theres a marco that can do this and if so, please share.
I want rows that contain any value other then 0 to be deleted.
Thanks in advanced.
Good Afternoon,
Myself and two other coworkers are working in an Excel workbook and now we are trying to share the workbook and it is "greyed out" (option not available for selection. There are no external links in the workbook, we all tried the select shared, even the creator but he cannot...
How many of you keep a cheat sheet with your most used and most useful formulas/macros on it? Just curious.
I've been thinking of starting one instead of trying to remember them, and remembering them wrong most of the time. That really makes me look good..."Hey, can you help me do such and...
Hi guys,
Has anybody ever written a loop that will make an INTEGER variable out of each column header in a worksheet? If so, could you please share the method?
thank you!
I have a table with a share portfolio on one sheet which includes the stock name and book values amongst other columns. Some stocks appear more than once (intentionally). Shares come and go so the table changes regularly.
From that table's data, on another sheet I want to summarise the total...
I need to share a complex model with potential clients while at the same time keeping it secure.
I've been using the excellent program XLS Padlock, but now many IT departments are blocking all .exe files (even camouflaged ones) via download or even usb drive.
Short of mailing the client a...
Hi Team,
I am new to VBA , Just started learning, if anyone has notes on vba, ya simple video to understand it.
Please share. my mail id - mallesh_gangadhar54@yahoo.co.in
Thanks a lot in advance !!!
Regards,
Mallesh
I need some urgent help.
I've created a search tool in excel which pulls some information based on the search criteria from SQL.
I've used SQL VBA method to retrieve the information.
It works fine on my system. However, I want to share this file on server or network so multiple users can...
After scouring forums, I have yet to find a solution to sharing an excel workbook without losing several features (Eg: macros, tables etc).
I have built a Customer Relationship Management (CRM) system within excel and have a need to share it with three other users.
Unfortunately, many of the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.