separate

Hello, I have the two rows: 26/09/2018 27/09/2018 28/09/2018 29/09/2018 30/09/2018 01/10/2018 02/10/2018 03/10/2018 04/10/2018 05/10/2018 06/10/2018 07/10/2018 08/10/2018 4 5 2 0 0 0 6 9 7 0 0 2 4 (copy/paste them in excel as I have no idea how to paste as table) In a separate cell, I...

I have vba to separate out invoice costs into separate sheets in excel. I need vba to add the total to those columns on each sheet. I other words, I need the macro to add the total to the column (I) and move to the next sheet and add the total to that column and move on to the next sheet.

I have in column B the following formula IF(F2>8997543,(LEFT(H2,(FIND("/",H2)-1))),(LEFT(H2,(FIND("-",H2)-1)))) This returns a unique reference which I then want to run a vlookup off in column C =VLOOKUP(B2,lookup!J:K,2,FALSE) I was going to nest the lookup but even separate I'm getting #NA...

Hi I hope somebody can help. I have exported an Outlook folders contents to a spreadsheet and I am trying to extract the dates from the header of when the email was sent to a separate column. Are there any formulas that can do this? Any help would be really appreciated. Thanks Ged

I have a excel sheet with first and last name in separate cells and hours planed to work fr each day in separate cells. I am want be able to enter the first name and last name and have the hours planed for each day fill in.

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Note: Fill colours not required, it is just to shown to explain the example clearer</SPAN></SPAN> I want a Formula or batter will be the VBA solution to " Separate counts depending on start patterns ", data in column C:D, count result in...

Hi, First off, I love this board! Very helpful. I have a report (excel format) of data that has the amounts for each date in a separate column: Descriptor Descriptor Jan-18 Feb-18 Mar-18 and so forth

I have a list of first and last names names which run into each other in one text string e.g. JohnSmith, DavidJones etc., is there a formula to separate these out into two columns - John Smith, David Jones?

Hi, I have a budgeting app that is missing a feature, so I need to perform this calculation manually. I would like to have excel do it for me if possible. Is there a way to distribute a remainder proportionally across the separate categories? In the sample below I need to divide 1.26 among the...

Hello I have a question how to pick and display only the whole numbers (integers) to separate column. For example i have a few hundreds numbers in column A. some of them are integers and I need them to be displayed in order in separate column let say column C so i can see them separate. ex...

Hello - I have file that is saved as binary .xlsb and have several tabs. I need to be able to select just a few of the worksheets(tabs) and save them as separate versions. Anyone out there with a code that can assist? Thanks!

Dear All, First i wana to say thanks to all for help me a lot. There is any possibility to extract pdf file in a separate separate file. Because i have a pdf file which contain approx 50 pages. i need every page with a separate name. Thanks: avisoft

hello, I have a a file which has info such as qty and description of items in the same column. I need to separate the info into two different columns or at minimum copy just the starting numbers to a separate column. The info is usually in this format with the info needing to be extracted or...

I have reviewed many copy/paste solutions on this forum, but so far haven’t been able to solve my particular problem – although I’m sure there is a simple fix ! I have a need to copy details relevant to individual passengers from a manifest and paste the details into a separate sheet. This will...

I have a shared workbook which is used by up to 10 users at a time, i need to construct a live "dashboard" on a separate tab based upon the data entered on an entry sheet tab. The dashboards will consist of statistics and charts, is this possible using pivot tables within a shared workbook or...

I am trying to take a list of Product Numbers in Table 1 and put a Type description next to it based on which column the item number appears in a separate table. I can get the separate IF/Vlookup statements to work individually, but not all together. Formula I'm using that doesn't work...

Hello all, I am trying to trim text that is in a column with a consistent header name in the worksheets but will be in different column locations (for instance sometimes in column AY and sometimes in column AZ). This is the macro I recorded where I searched for the column header name, inserted...

I would like to combine 12 separate workbooks into a single Workbook but have the data from each in a separate Worksheet. Any suggestions on how to get started?

Dear all if i have many tables and each one in on separate sheet and lets say that they have values in 1st column like ppl names i want to make one big table (in separate sheet) containing all ppl names inserted in all the tables without duplication can i do that automatically ? thanks...

I am working on a workbook that will have four sheets, each is a bank register. The first is the main register that houses every transaction associated to the entire account. The remaining three are what I am calling "T-Accounts". In Column "I" (labeled "T-Account") there will only be three...