excel

I have an excel userform where I can search for and create new database entries in an ms access table. But when I try to edit existing entries it gives me an error that the object doesn't support this action. here is my code so far: Private Sub EditButton_Click() Dim con As Object...

I have a worksheet with a drop down list in "B2" to filter the data and I have a code to save the viewed information in the sheet as PDF to external forlder "D:\Desktop\Daily Tasks" and to name the file based on cell value in "C2" My drop down list has only 5 items (NH01,NH03,NH04,NH05,NH06)...

Hi, I am trying to make an excel userform that connects to an access database. So far I can search and create new database entries from withing excel. But I can't seem to populate my listbox with a selection of my database table. Here is my code for initializing the userform and fill the...

Hi All, I've searched this forum and others without success solving this weird problem. It might be an Excel bug, but I'm hoping it's just something I'm doing wrong. My fairly basic spreadsheet has two userforms. One works perfectly well but the other won't even load. It did when I first...

I have found a code on the web to send excel file as attachment and modified it to settle my needs but I need your professional help to add my signature image to the email body and to make the email body text to be set as (Right to Left) here is my code and screenshot of my email signature need...

Hello, I am pretty new to excel and I am trying to create a macro or by using equations to detect when a row is highlighted, the content in that row gets copied and pasted in another sheet in a specific row. How do I go about doing it? This is an example of the data in sheet2 (where the content...

Hello, I'm struggling with the sumif function on a table. I want to be able to sum a range based on the header row, and two column criteria (Sub Type and Prod). To get the sum value of Apple in Act Jan for Tag1 - I tried the formula below =SUMIFS(Table3,Table3[#Headers],I5,Table3[Sub...

I created a spreadsheet to be a search tool for our client directives and instructions. Each entry in the spreadsheet has a link to the actual document. To ensure the security of the data from unauthorized or accidental changes, I upload a copy of the master file to our local network for people...

Hello everyone. My company just purchased an app for my every workflow. The App is a link AppSheet. My question is that how can I link my excel to the AppSheet? I tried import data from web but it didn’t work. I tried google it, it says go to my account setting in AppSheet but company provides...

Looking for some help with a formula to calculate the total requirement of a part over multiple variants. Example below: Part list with Type Quantity Type1Type2Type3Type4Type5 Part101234 Part240123 Part334012 Part423401 Part512340 Type demand for each WK WK1WK2WK3WK4WK5...

I am creating a SKU system for a huge catalogue of items that will grow and grow over time, I'm looking to future proof with a SKU that can create over a billion variations so I will never run out and is easy to understand I'm looking at the following: AA0A0AA AA0A0AB AA0A0AC up to: ZZ9Z9ZX...

I've used Spreadsheet Compare to compare 2 spreadsheets and got Export results sheet as an output. Does the Program have a switch or option functionality of giving me a better, user-friendly output that shows me which rows have been deleted, added or changed on the sheets? I'm not looking to...

I work from both Microsoft and MacOS platforms. I am in need of a macro that will add a checkmark to a cell easily. I have tried using code from a previous request "Using VBA in EXCEL to add a checkmark to a cell" but it will not work on my new Microsoft machine and I am not sure it will work on...

I need an Excel formula that checks for value between 2 seperate ranges. Check if value is between (.0406 and .0483) or between values (-.0483 and -.0406). Either value is OK in the Same Cell I tried and if statement. This one Didnt work however. This is what I have. However the code only...

Hey Team, I'm trying to reference multiple different rate sheets for my estimating sheets. To start simple, all I want to do is have a table on my estimating spreadsheet that shows either the info from Administration 01 on rate sheet 1 or Engineering 01 on rate sheet 2 based on maybe the info...

Hello dear excel-lers, I have a workbook that helps me to record people's phone attendance on weekly basis. Each sheet is a list with names and timeslots. Users then are expected to choose from a drop-down menu 1 of 3 options (1-office, 2-home office, 3-formation). There is also a formula that...

I have a worksheet that only receive updates from other sheet with filter formula, no manual entry at all occurs in this sheet and I need a code to add the current date Now() in cell "C3" as soon as the sheet receive any update from the source sheet .. I have a code but it insert the date based...

Hello, I am trying to unzip a file for folder based on Cell Range. For Example Cell Range A1: have my file name (xyztestfile.zip). I am new to VbA and need help

Hello, I have an Excel spreadsheet that has a list/table of trained employees. when I click on the employees surnames it opens a hyperlink to an individual training completion email file. The email files a stored in a folder on a shared company drive. What I would like to do is create a number...

I have a workbook that I need to select rows that have cells numbered in one worksheet, import them into another worksheet, sort them based on a value in one column, The first worksheet can be 150 rows long and would look like the table below (with data in columns C through O too)...