separate

What VBA code can copy and paste data in separate workbooks all in the same file folder with the same column headings and all on Sheet 1 into a separate workbook?

Hi there Excel-people :biggrin: For part of my job I have to take data from one Excel list and make it in to separate Excelforms. It takes up so much time, which I don't have. So I was thinking... Is there a way to merge the Exceldatafile in to separate Excelforms? (We use the later as a sort...

So i have a cell with which as the following in it - 100 > m > 10000 - In my case its in cell A21 Is it possible to write a code that seperates the 100 and 1000 to another variable?

Hello, I am searching for a few lines of code in Excel that would search a column (D4:D999) and highlight any cell that contained lowercase letters yellow. In addition I would also like the code to search a separate column (G4:G99) for a name. If the cell equals the name, then look at column...

I am trying to work out a way of identifying individuals in a random list as opposed to non-individuals, where each individual does have a known identifier in a separate list. And then cutting out the entire row where the individual is identified to paste into a separate sheet. For example in...

I am trying to create a 1 Click button that will attach each sheet as a separate PDF file with the sheet name as the file name to an outlook email. I am currently able to accomplish the above but it merges all the files into 1 PDF. They need to be separate.

I have a spreadsheet with employee information data, on a weekly basis I have to add data to the spreadsheet. I have a separate tab in same workbook that I create a pivot table based on employee information data. I update the pivot table on weekly basis with a simple refresh. The pivot...

I have a string which will include text, numbers and punctuation. It's free text so it's never constructed in a consistent fashion. Within that string, there will occur 4x 5-digit integers. Sometimes the integer will be preceded by a space or a symbol (like " 12345" or ":12345" or "-12345" etc)...

Hi MrExcel group :) To the sheet below, I would like to add another set of stats to separate average days at fledge for males and for females (without trimming the mean). Male and female designations are in the name column. I should be able to do it as is without making a separate column for...

Hello to everyone. I use this code to split text in to separate colums <tbody> Row/column A B C D E F G 1 Split text in rows 2 Split text in rows 3 4 </tbody> Sub SplitTextColumn() Dim i As Long Dim vA As Variant For i = 1 To Range("A1").Rows.Count vA =...

Hi. Please, in case is possible, I have a dynamic array five columns, the first column is only two words alternated and the other four columns are numbers (grades). what I need?, I need to separate the rows of math from the row of geography and convert in two different arrays. Thank you for...

I know that =text(a2,"Dddd") will give me a day of the week, and can also use the WEEKDAY function. Is it possible to use one of these within another formula? Example A2:A7700 has a bunch of dates. i want to calculate how many Sundays, Mondays, etc. there are in the list. I guess I could use a...

Dear all, I need to combine 300 words in a column (separate cells) in to 30 words in single cell each. I will have to do it many more times.... I use the forumula =concatenate(transpose(INDEX(A1:A1000,30*(row()-1)+1):INDEX(A1:A1000,30*(row()-1)+30))&" ") and drag it down. Problem is I have to...

Hi All, I use the following code (found here) to do the following: - Save - Set up a Windows prompt that will re-open the Excel file in a few seconds - Close the workbook - Prompt triggers a re-opening of the workbook Sub SaveCloseReOpen() Dim strCMD As String strCMD = "CMD /C PING...

So I have a form where its workbook is hidden. The user opens a file which generates a separate open workbook. My problem is when I close this other workbook, excel prompts me to save/unsave my userform too... I've included some code in the ThisWorkbook module that allows me to close a separate...

I have a cell that has multiple series of info in it, separated by commas. Is it possible for a formula or a way to separate the info in the cell into separate cells using the comma as a start / end point A1 = stop, Tuesday, Blue, four, Loud, Yes Thanks in advance

Could you please help me to code the following: I need to pick only the integers/float from a particular line of the text file (say line 2 qnd 3) and store it in an excel with each integer in a separate cell in sequence? text file: [Page1] MotorP_AvgTemp= 10, 11, 1.25 MotorP_PackVoltage= 60...

I have a code that prints the 52 week range (i.e. 49.77 - 79.90). I would like to separate the numbers (49.77 & 79.90). I would be using each number in a label. Can someone assist. Thanks

Morning all i have a document that prints labels, the label has a template sheet and then VBA code cycles through data to populate each label and prints, if i print directly to the printer everything is fine and it prints in order. what im wanting to do is print to PDF, i can sort the code to...

Hi, first time poster here...go easy! LOL I have a spreadsheet and in the asset column i have a list of numbers related to that one line of information. All separated by a comma <tbody> Number Title Rev Asset total amount of assets UC02-WPD-UT-REP-N001-000012 Network Design - N1 P01...