Excel Forum
-
problem search data by selected combobox & datepicker tools
hello i no know why this doesn't work this code and there is no error it should when i select from combo box it should ...
-
how can I unmerge cells, delete empty col and rows, relocate cells and combine? [Solved]
Hi dears, first of all, I have to thank every one who read this message and he try to help me. its a complicated matter to me. Actually,...
-
Count cells containing text per row
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each...
-
how to hide/undie picture based on a cell A1=1/0?
Hello, can anyone help me how to hide/unhide picture 1? if A1=0 then hide picture 1 if A10 then show picture1 thanks System...
-
transpose data from vertical to horizontal [Solved]
Hello, this the code doesn't work i would transpose as what in existed in picture the result from e: h i hope ...
-
copying formula for multiple worksheets
I use ASAP utilities to insert multiple worksheets using a template. I'd like to create a formula that automatically inserts sequencial numbers. ...
-
adjusting code divide data of table into tables in each sheet [Solved]
hi, my code really works but the problem when i add a new data it doesn't copy to the multiple sheets because the first ...
-
how can i blink data in textbox on userform based on condition [Solved]
hello i got this code from the internet about blinking in textbox by command button but i would do this without command button it's...
-
Excel - How to count numbers in Brackets
Hello, I would like to know how to count the number of elements(digits) in the brackets after a word. exemple Bimbia(1,2,3,6,7,8). in the...
-
fixing sum an subtract among sheets [Solved]
hi, i search so much in the internet to fix my code to work but no answering so far i have 6 sheets it suppose copying data...
-
gestion des creances clients
Salut ! C'est ma toute première fois de poster sur ce forum et vu la performance des membres de celui-ci je sais que j'aurai une réponse à ma...
-
Generating report sheets
I was developing Excel program for students' results calculation . How do I generate report sheet for all the students...
-
VBA Function code to highlight Odd and Even numbers [Solved]
Hello, I am trying to write a VBA Function code to highlight Odd and Even numbers. But not having much luck. Can anyone help me, please? I...
-
Help: Need formula to find missing text comparing 2 cells
Hello guys I have the same issue. A2: The price includes VAT B2: The price In the next column, I want the following value (the text...
-
VBA: Color cells in table based on multiple condition [Solved]
hello i do code by loop but it doesn't completely work i appreciate if somebody help me why it occurred and give me the alternative ok...
-
How to specify macro for current active sheet [Solved/Closed]
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is...
-
Excel make cell flash red [Solved/Closed]
Hello, In Excel I can make cell red when formula is greater than 4 but how do I GET CELL TO FLASH Office 2003 And can you in same...
-
inserted row should paste in 7times in next sheet based on the date [Solved]
Hello, i have a template and from client a workbook will i should compare and paste the data if any new row der i should insert in template...
-
VBA to reference newest sheet
Hello, Im a complete beginner in excel and the vba process. I'm trying to make a macro create a new sheet, copy the style/structure from a pre...
-
Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes
Hello All, I have been struggling to find a code that allows me to select multiple columns by name to then delete duplicates in those specific...
-
Date counter and then stop when new date is entered
I am attempting to calculate the time between B9 and Z9. and the same with D9 and Z9. the person who created the file is only calculating from...
-
vba error -2147417848 (80010108) automation error
So I am trying to make a spreadsheet that tracks our usage by diameter and individual serial number. I perform some basic checks using conditional...
-
Macro to compare 2 sheets and copy differences [Solved]
Hello, I’ve been working with this macro to compare two worksheets and copy the matches to a third sheet. Not knowing vb very well can someone...
-
Combine Cell Text [Solved]
Hi, I am after an easy way to combine text in several rows into one cell. The number of rows that need combining will vary from 2-...
-
Copying data from one Excel sheet to another. [Solved/Closed]
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy...
-
Copy rows from Excel to another sheet once a date in a specific field is filled [Solved]
I have a current spreadsheet that lists our customers, job names, and delivery dates for the materials. I would like to have those lines copy...
-
Cells copying and pasting in a empty cell of another sheet
Hello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example)...
-
Punching Time [Solved]
Hi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the...
-
Date Am and PM but need the date to change [Solved]
Hello, I have 12 workbooks, what I am trying to figure out is I have the date and time in one cell. But I has it 1/1/2020 00:00 then them next...
-
Copy x rows y times and then insert customer ID on each set of x rows [Solved]
Hello, I have a set of criteria, 56 criteria as of now, and I have to check how many criteria each customer meets. In one tab I have the list of...
-
Transferring data autonomously to another sheet with certain text
Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'....
-
Averaging data on inserted rows in Excel
Hello, Please after successfully inserting specific number of rows in excel, is there any code that can help you average the data on the...
-
Calculating normalized standard deviation in rolling window
Hello, Please how do I calculate normalized standard deviation in a rolling window for positive and negative values? System...
-
Populate data from a column in one worksheet to a cell in multiple other sheets [Solved]
In a workbook, I want to be able to copy all the cells in column B of sheet "Raw Data" into multiple copies of an existing template sheet...
-
Extracting images from a database but named with a specific cell content.
Hi there people! I could use some help... I'm currently importing product images from a database into Excel using the Visual Basic code...
-
Find out date filling cells [Solved]
Hi, First of all thanks for your help I have a big excel file which I have been filling it for the last 2 years. There is a way to find out...
-
Using VBA Code to extract data from a website
Hello, I have little to no programming knowledge or how to work with VBA. I was wondering if there was a way to write a VBA code to extract...
-
How to hide text in a Excel cell and display it when needed [Solved]
Hi friends I have doubt in excel. I have a column called 'Status' and want to show the text either as 'Pending' or 'Completed' depending on ...
-
Seperating time from text [Solved]
Hello, I have a task in my office that i can't get done and it is very impossible to finish within 1 week as these are 14,000+ orders. The...
-
adjusting code transfer data from combo box & textbox into userform to sheet
Hello, i would help adjusting this code it doesn't work it gives me error when i transfer data to sheet i want to begins transfer...
-
conditional formatting to show when job is done
HI, I have work tracking file. all is running good only i want to have conditional formatting in it. for example:- in sheet dme, column...
-
Excel project
I’m in pompano beach Florida searching for a freelancer for this excel project. Not much success yet. Any help would be appreciated
-
Update Master / Summary Tab with all new entries in other sheets / tabs
Hello, I have a workbook with 9 worksheets; one of the sheets is the master; created to be the other 9 sheets compiled into 1. I need to set...
-
Working on the same workbook from 2 locations
Hello, my name is Marshall and I'm a Logistics Planner. I have created a load schedule on Excel for every day of the week, depending on how many...
-
VBA: Delete empty rows based on value of cells [Solved]
Hello, my code works transfer my invoice from sheet1 to sheet 2 but my problem i would adjusted my code to become delete rows from a19:...
-
Excel linking to word
Hello, Please I need assistance, I want to link and excel worksheet to word document and be able to edit it on word without having to open the...
-
Transfer data from one Excel file to another
Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?
-
How to simply this Excel formula [Solved]
Is there a way to make this formula...
-
VBA Compare 2 sheets and output difference to 3rd sheet
Hello, I am trying to make a button on VBA that will take compare two excel sheets, and identify new numbers in a certain column and copy and...
-
Serial numbers
Hi, Can someone help me create a series of numbers? I ran out of numbers. Please help me do this numbers. I need maybe 5000 numbers for this. here...
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty