manage

Is it possible to have a Picture on a UserForm and have its size change with the Form as you drag the bottom right corner ? I have this working on some other platfoms (Access, VB6) but can't seem to manage it in Excel - or the Picture flashes white bars while moving. Any help much appreciated.

I have a spreadsheet that I use with the sales force. I want to send out the spreadsheet but I want to make it such that the reps can only see the customers they manage. I want their Usernames to be what limits their view. Is there a VBA code I can use?

<tbody> CR - 2016 AB - 2016 CR - 2017 AB - 2017 CR - 2018 AB - 2018 Nov 3711 2382 6533 1344 6474 781 Dec 3218 1378 4886 484 5370 671 Jan 3702 2004 5962 790 6031 386 Feb 3840 2494 6132 601 6288 1097 </tbody> Hi All, I’m after some assistance with...

I am working in a indutstry as store keeper. i want to manage store inventory but can't find a proper way to do this. could you help me how to manage this.

I am working in a indutstry as store keeper. i want to manage store inventory but can't find a proper way to do this. could you help me how to manage this.

Hello I am a software tester and I will soon be carrying out end to end testing which will cover a period of 6 years. Without the luxury of software tools I will utilise Excel. Currently my plan is to make every column a day (2192 columns), and every row a person (up to 500 people). Every...

Hello everybody. At the beginning of a macro, I've stored a range in variable rng and then I've deleted it from sheet1. At the end, I've to "paste" it in another position, starting from row z of column A. How can I manage this job? ps. my unsuccessful attempt: rng.Insert (sheet1.Cells(z, 1))

Hello all. I have 2 tables in separate worksheets (same workbook). First table is tblUnitList, second table is tblUnitLocation. I would like to manage tblUnitList and have tblUnitLocation updated whenever an addition, change, or deletion is made to tblUnitList. tblUnitlist consists of a header...

Hello everybody. I've a value in a cell in hour format: 00:05:37 I need to transform it in seconds: 337 How can I manage the matter? Thank's.

Hello friends, hope all is well! Please help me. I have 5 workbooks (WB1,WB2,WB3,WB4,WB5). Each workbook has 1 sheet. These WBs have the same order of column headers. I have a separate workbook that will have a PowerPivot. I want to see the contents of the WBs in the sourcedata (Manage...

Hi folks, I run a medium/large IT company and we currently have open negotiations with 35 different organisations. We are currently using a combination of Excel and Mail for Mac to manage and keep track of these numerous contract negotiations. Excel: a table listing company, country...