help needed

Hi everyone! I have been asked to lead a presentation for my company. I have a shortened list of some of our sales staff and a longer list with all staff. Is there a way to transpose a list of quarterly performance from the shorter list onto the longer one whilst keep any gaps? I am fully a...

Good Morning I am looking for a little help if possible. I have data that needscoverting to an hh:mm:as format. the data I am getting is in the following formats and need it all changing to same format as above. 22s 22m 22s 2h 22m 22s any help would be much apreciated

I have a table with the following columns: Account, Sub, and Split. I'm trying to create cascading data validation lists where you first select the Account, then the Sub, and finally the Split. So in the table below if I chose Account = 501650, then Sub = 00-240, the third Split list should...

Hi everyone, I really need your help. I'm working on a project that takes a lot of time. It's for accounts payable. This is done mostly and it usually has thousands of lines. The objective is to find debits that are made up of different credits (values on different cells) or viceversa. I used...

Hi all, I need to know if theres a way you can make a formula for the parameters below- Plus 9 except when reaching a multiple of 10, then plus 10 then plus 19 then carry on with plus 9. For example- 12512, 12521, 12530, 12540, 12559, 12568, 12577. Many thanks if this can be done! Don't...

Hi, I have an issue. I have some data in Excel which I need to covert. The data is in the format: Mon 12/30/2017 where it needs to be Mon 30/12/2017. I have tried Data>Text To Columns>DMY with no avail - so please do not mention that. Helpful advise welcomed as it's bugging me! Thank you.

Hello, I'm hoping some one can get me started building this excel spreadsheet... I have only a tiny bit of excel experience I think this spreadsheet should be real simple and only have a few calculations... I'm thinking the only Data needed will be: Current Date. Current Vacation...

I'm making a spreadsheet for work purposes and cannot quite manage to figure out a formula for some of the data they require, the info is as follows: TAB Name: APPS Column A: Surname Column B: Forename Column C: Sex (M/F) In a separate tab ('INFO') I need to calculate the most frequently...

Hi all, Struggling with a macro that I am using to scrape some data from a webpage. The code is as follows and is placed in a Module. Sub getdataEnglish() Application.Calculate Dim result As String Dim myURL As String Dim winHttpReq As Object Set winHttpReq =...

Can someone kindly help me, I am so stuck! My boss made a workplan in Excel and we want to sum the number of hours each person has of work in a month across all tasks. The output table should show something like this <tbody> Name Jan Feb Mar Person 1 4 2 Person 2 1 7 55 </tbody> The...

I basically made an invoice for my course work for a computer shop and I designed it so you can select the products using a dropdown list on a userform onto the invoice. Then I make it look for the price of the product from another sheet called products and stocks but for some products it brings...

I am trying to set up a spreadsheet for work and am having a bit of trouble. I have created a drop down list, well two actually. These are in A2 & B2. From here I want cell C2 to display something from another worksheet depending on what it says in these two columns. The other worksheet will...

Hello,<o:p></o:p> I am having a slight problem with an auto-sorting macro onan excel sheet. I have a sheet with aheader on row 2, and columns from A to Q, and the information on rows 3 to22. The issue is coming up from columnsB and C. I need the values in column Cto sort greatest to smallest...

Hi Guys, I have a an error "Application-defined or Object-defined error" popping up and it's wrecking my head trying to solve it! Basicly I have a ListBox "DataListBox2" which when populated I click on any one line in the list box to get info displayed on the Userform "CustomerDataUserForm"...

Hi everyone, Apologies if this has been answered before. I am creating a rebate calculator for my business. Some people get rebates based on every order (TYPE1) (i.e. £0.1), others get volume based rebates (TYPE@) across the year, i.e. if they order 1000 items they get £0.1, 2000 items £0.02...

hello I want to do the following some how Sumif( Colum B & Colum E, are between 0 and 30 and facility of loan >500 the sum range colum is ColumG) Any ideas thanks

Hi, I've seen here some code samples which worked for different people, yet i cant manage to make it work. facts: I've checked the trust vba module in the trust center. cell A1 contains the filter value 1 (i want to show only rows that contain 1 in column a) table data on...

Hi everyone, I have a sheet with a couple thousand rows of data. I need to calculate the subtotal sum for the first 50 rows of auto-filtered data. I can't seem to figure out the formula that I would need to have to do this automatically. If for example my filtered data the 50th visible row...

Hi everyone, new to posting on this forum so thank you for your patience. </SPAN> </SPAN> I have a spreadsheet which has data in 7 columns and around 100 rows. I want to be able to find what two numbers appear most frequent together on each of the rows. They don’t have to appear side by side...

Is it possible to run a VLOOKUP or other formula to compare two worksheets, then if Cell A is present in both of them return the whole row on a third sheet? Is this possible?