data

Hi, all, I have a userform with 5 input fields, four of which are textboxes (the other is a combobox). Two of the fields ask the user to input a date in the format dd/mm/yy, and one of them asks for a number. Currently, these values are added to the worksheet as text values, even though the...

Hello, 1. using VBA, i am trying to think of a way to copy values from a whole column in workbook1 worksheet "sheet2", starting from column F on sheet2 and X number of columns to the right and paste the values into another workbook, lets call it workbook2, and the worksheet the values will...

Hi I am trying to copy various row data on one worksheet that has been identified by conditional formatting on another, I.e a number identified as appearing on second sheet, I would like to copy the columns into a section on the first work sheet on the same row it appears. I'm not a VBA coder so...

Any help would be greatful! Looking for a way using python or VBA to basically transfer data from workbook one to workbook two. The yellow cells and the light grey cells are the areas where data will be put into. I know it may show two rows, but the user is able to have multiple. As you can see...

Hi all, I've searched around but can't find any instance where this problem has been solved. I've got some queries set up in Excel (2016) that get stock data for the day from a website. Typically I'll open the workbook and hit refresh all, and the data loads. Today, though, it's loading...

hello, I have a text file with blocks of data defined by parentheses, something similar to ( asas dsdss ) ( wwqee weqqe ) I need to extract the content between the parentheses. the problem is that sometimes the parentheses are nested. any suggestions? Thank you

I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...

NOPQR1DateIDCostSorted...

Hello everyone. I'm not good at explaining stuff, but I'll give it a ago, since I'm stuck - I've included pictures, since it's troublesome to describe in text - I hope that's okay :) I have a data-sheet, from which I've created the pivot table shown below, displaying amongst other things...

Hi There, I want to make a excel sheet that can do the following : I want our sales team to enter all the bookings information on sheet and then create a tab for every course, as they enter the bookings in the input sheet it should allocate the bookings to the specific course tab for example...

Hi. I have been trying to modify and insert this code into an existing macro code. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String On Error GoTo Exitsub If Target.Address = "$C$5" Then If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing...

Hi, this may seem a basic question but I really cannot figure out how, would appreciate some help I’m training to be a business analyst and have a table with 30 leads in column A then B is 01/01/2020 and the corresponding cells are filled to show how many leads we’re getting from each lead...

Hi all, I am trying to collect FInancial data from reuters.com, using Data - Get External data - From Web, where I simply paste, for example, this link AAPL.OQ - Apple Inc. Financials | Reuters and click Import. However, when I get the data in Excel, I see everything except for the table...

Hi, I have a huge data which is converted from another source to excel required to be set in Tabular format with help power query.Headers are already available it should be same as it is, Blank columns and rows to be remove, Data in column which does not have any headers to be create a new...

Hello. I am trying to copy/paste data from 2 columns (containing several rows with required data) and transfer the columns to another worksheet in the workbook over a time span of either 23-24-or 25 hrs The problem is that I need to use an argument what is not consistent and I have a macro in...

Hi all, I need help with an excel macro. I have only started to use macros and as a result have a very basic knowledge and understanding. I was wondering is it possible to create a macro that can be reused even when the raw data coming in changes the position of the cell that the macro was...

I have a spreadsheet with hundreds of lists that each have a header and vary in length. The headers all follow a similar format (ABCD 123AB) and I want all columns for which the headers share the first 8 characters (including the space) to be combined into a single column with the header being...

One person should enter the data with his password, and his name should come in "issued by" and other person should accept the data with his password and his name should come in "accepted by". Till he accepts, it has to be in different colour. if he rejects it, the data shouldnt disappear, it...

Hi, I have a complicated situation with an unwieldy amount of data. The situation is I have data from my website in excel, each row is a profile (around 100k profiles), that all biographical data is crammed into one data field (or in this case, a cell, since in Excel) in HTML format. The HTML...

Hi, I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in excel. I know the excel trick where I can import the data in excel/or open with excel and use the...