data

I am trying to make a data validation list on Sheet1 that references all non-blank items in column A on Sheet2. I have accomplished this pretty easily (although, is there a way to exclude the header without just selecting a long range like "A2:A5000"?). Now, I want to trim that list to only...

Hello! In QR we have an enter after each row, which works fine in notepad when scanned with barcode scanner. But in excel it just outputs one string and sounds an windows "error" sound when it's supposed to output the enter. Doing the exact same thing with tab works just fine, no issues, it...

Hi Excel Experts, I am looking for one small automation macro to filter the data below and need to keep one set of data from the input to the output. We have three columns below and Col-1 where "Y" is applicable in Col-3 then Col-1 cell value should be base and corresponding Col-2 data...

Good Day Everyone, I have a Bit of a Funny Issue that I'm not Sure what could be Causing it, as it Only Happens to One User while the Rest is Fine. I have a Template that is Used by 5 Data Captures in the Company, Very Simple, on Sheet One(Data) I have the Data Range to be Used in the Dropdown...

Hello excel experts, I have annoying (crappy) data, and I am trying to grab all names from a column that meets a couple criteria. In that column are subtotal rows with a count of names and a TOTAL heading, and category headings like: - 2020 Sold Properties - 2020 Completed Refi - 2021...

Hi everyone! I have a spreadsheet to convert the (attached picture) in green to rows in yellow. Is there possible formula or code to create the remining data from rows 7 thru 24 to columns L thru V) ? Here is steps example for manual input (to convert green row 2 into yellow rows 2, 3 and 4)...

Hello, I have an absence tracker which records absence in a current 6-month rolling period and a previous 6-month rolling period. Each occasion of absence is recorded as a separate row and absence is manually added to the "current 6 month" sheet daily (as it occurs). A piece of VBA code then...

Hello, I use the below code for my absence tracker which was kindly provided on here. I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at: Current 6 months Tab - All absence in the last 6 month rolling period from...

Hello I would like to ask if and in what way it is possible to create a specific print report in excel. I need to print data from Excel in a specific format, where each cell in the column has a designated specific place in the document - from one line in Excel, make 3 on A4 in the printed...

Hello, I am struggling with quartile formula to calculate the selected value in another tab based on the description and grade. In the workbook I have one tab with all the data range based on description (i.e. Maths - A, B, C) and in another tab I need to calculate 3rd quartile for grade A, B...

Hi, I had a question. I wanted to convert non-uniform data in single Excel column to uniform data into another column. Example- I have an Excel column containing values as 345.12 million, 128.56 billion, 2.67 trillion and I would like to convert this non-uniform data into a uniform way using VBA...

I want to merge files "Data" which are in "select input folder"button and "select output folder"button into one file Both the files "Data" Should Merge When I click Execute button Is there any macro to dd?please help me out

Hi all, I have raw data that I want to convert to be read easier. There are lines open between each statement. 1. I would need the payment date(M67) to be pasted in every row in column K(In photo - K75 and K76) for the transactions 2. I would need the Internal code(C68) and code(C69) to be...

I am trying to write a code using Selenium Basic. I am extracting messages from a messaging service. I can extract all the messages using FindElementByClass, however this returns all the messages and does not contain any details of who the message is from. I need the messages returned to the...

Hello, I have a table with A, B, C and D down one side and A, B, C and D across the top, in the middle of that table are values. I want to get excel to then be able to find the value of any cell, for example A,C or D,B and so on, and provide the value. Any help would be greatly appreciated...

Hello Everyone, I am learning C++ programming and working on a project. I want to know which programing language separates the function and data between C and C++ programming. According to this source, In The case of C++, the data and functions stay encapsulated in an object’s form but not an...

Good afternoon, I have this table of data, and i would like to be able to copy each row of data into another sheet depending on the country name. So if the country is Belgium for example, it would automatically go through the whole table (if data is added in the future) and take all the rows...

This is my full code Sub StripData() Call InsertData Call FormatData 'Call DragData End Sub Sub InsertData() Dim myWb As Workbook Dim myRowsToCopy As Range Set wbtemplate = Workbooks("Template.xlsm").Worksheets("Raw") Set formatrange = Range("B2:CE2") Set formularange = Range("AK2:CE2")...

Dear all, I have currently made a pivot table, which I am linking to some Power Query data. The data in the power query comes from a folder where I import files from a website, so these files will ALWAYS have the same file name, sheet name and column names. However, the data under their...

Hi all, I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query. I want to import data into this pivot table (not using power query below): I have the source data saved here: So questionnaire data file 1 is week...