datasheet

Hi everyone, its my first time using VBA and any sort of coding in general so I have been cracking my head for weeks trying to do this UserForm . I'm wondering if there is anyone here that could help me with it? Any help is appreciated, Thank you in advance!! I have 2 main issues that I've been...

Hi, I am creating a summary sheet book with hyperlink icon or hyperlink formula to the another workbook “datasheet“ however i found the below issues. 1. For the right click and create hyperlink, it is easy to do but when I save as the summary sheet workbook and the another workbook "datasheet"...

Hi, I have a workbook 'workbook A' which contains the worksheet 'Datasheet'. Datasheet contains all data validation drop-down lists in this workbook. I would like to replace 'Datasheet' with a sheet from another workbook - 'workbook B' - also named 'Datasheet'. Is it possible to do this...

Good Morning All I have a datasheet that looks at health interventions in an organisation. A data feed I receive populates the datasheet with the dates on which these interventions happen and I calculate the next due date of the intervention for an individual - nothing complicated, quite...

Hello, I'm new to VBA, so apologies if this seems a simple one.! I'm currently working on a stock check spreadsheet which contain a stock list with datasheets numbers (these would be typical numbers, but the cell may contain more than one) and size, and a requirements sheet with a typical...

found this piece code and its exactly as presented. It works in the provider demo, but not in my new workbook. Error occurs at the bold red print (object define error) Sub search_and_extract_singlecriteria() Dim datasheet As Worksheet Dim reportsheet As Worksheet Dim typename As String Dim...

Hi Team, I have created an onboarding form for employees and there is a worksheet where the data is getting stored. The problem is now there is a runtime error coming in a listbox click function where all the records are displayed from the datasheet so in case of any modification user dont...

excel 2016 I have 40+ columns of data in 100s of rows. At a specified time each day I need to copy each row sequentially to a single row in a new worksheet. As an example: DataSheet is the sheet from which data should be copied. NewSheet is the receiving sheet. Process would be as follows...

Hello, I have a datasheet with 35000 datas in one column and I have to compare it with another colomn that contain 10-15 lines. The problem is that the way they are written are not the same. For example in one column I have : Microsoft Visual C++ 2008 Redistributable - x86...

I have two sheets in one workbook. DataEntry and DataSheet. One of my teams input data in rows on the DataSheet using column C as the account number, then column D as customer name. My other team goes into the workbook and will use the DataEntry sheet to search for data by account number in...

I have an excel sheet with datasheet tab and profit_loss tab. In the datasheet i enter dates and rent collected I am using SUMIFS function to extract data from datasheet tab to profit_loss tab using the dates in the datasheet tab. If I change the year in profit_loss tab the amounts in the...

Hi- there are 2 sheets: sheet 1 is the Importer and sheet 2 is the Datasheet. I need to bring specific data from the DataSheet to the Importer using variables...not copypaste. I'm using a while loop to place the DataSheet data into the appropriate variables. It loops through the data just...

Hello, I have been searching the internet , but unable to find the answer... I have a sharepoint list which displays perfectly in Standard view, if i try and switch to Datasheet view , I just get a blank grid. I have asked colleagues to try and they get the normal excel/access grid format...

Hello, need help to create the order sheet, data and image from datasheet to order sheet with v lookup.

I have a specific code structure that I would like to be automatically generated based off of text from other columns in the same row. The code Structure is: XX.XXXX.XXXX (PROCESS AREA . COMPONENT/DISCIPLINE . ITEM) The first two digits are meant to represent an "Area" (##.XXXX.XXXX) The next...

Hi, I need help with excel. I have database of my daily work tasks which includes different dates in one column and in the other columns I have other datas that are mostly in text. Now I need an excel code/function that can provide a "summary of tasks" that I did by each date listed and a...

Problem #1. I have a custom Tasks table that does not display the Primary Key (Task ID) column when I switch to Datasheet View. In the Design View the column definition it is at the top of the list of all the columns. Is there an option on a table, column, or key to disable its display in...