Excel Forum
-
gestion des creances clients Closed
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 question...
-
Generating report sheets Closed
I was developing Excel program for students' results calculation . How do I generate report sheet for all the students individually????? Thanks in...
-
VBA Function code to highlight Odd and Even numbers Solved/Closed
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 would ...
-
Help: Need formula to find missing text comparing 2 cells Solved/Closed
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 difference...
-
VBA: Color cells in table based on multiple condition Solved/Closed
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 let'...
-
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 selecte...
-
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 spreadsheet li...
-
inserted row should paste in 7times in next sheet based on the date Solved/Closed
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 file an...
-
VBA to reference newest sheet Solved/Closed
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-det...
-
Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes Solved/Closed
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 colu...
-
Date counter and then stop when new date is entered Closed
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 "Today'...
-
vba error -2147417848 (80010108) automation error Closed
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 for...
-
Macro to compare 2 sheets and copy differences Solved/Closed
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 show...
-
Combine Cell Text Solved/Closed
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- 10 (Would be...
-
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 the da...
-
Copy rows from Excel to another sheet once a date in a specific field is filled Solved/Closed
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 automati...
-
Cells copying and pasting in a empty cell of another sheet Solved/Closed
Hello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example) must...
-
Punching Time Solved/Closed
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 orders ...
-
Date Am and PM but need the date to change Solved/Closed
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 lin...
-
Copy x rows y times and then insert customer ID on each set of x rows Solved/Closed
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 the ...
-
Transferring data autonomously to another sheet with certain text Solved/Closed
Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'. Bot...
-
Averaging data on inserted rows in Excel Closed
Hello, Please after successfully inserting specific number of rows in excel, is there any code that can help you average the data on the inserted ...
-
Calculating normalized standard deviation in rolling window Closed
Hello, Please how do I calculate normalized standard deviation in a rolling window for positive and negative values?
-
Populate data from a column in one worksheet to a cell in multiple other sheets Solved/Closed
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 correspondin...
-
Extracting images from a database but named with a specific cell content. Closed
Hi there people! I could use some help... I'm currently importing product images from a database into Excel using the Visual Basic code below: ...
-
Find out date filling cells Solved/Closed
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 the da...
-
How to hide text in a Excel cell and display it when needed Solved/Closed
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 the ...
-
Seperating time from text Solved/Closed
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 sheet ...
-
adjusting code transfer data from combo box & textbox into userform to sheet Closed
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 dat...
-
conditional formatting to show when job is done Closed
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 f12:f50 is...
-
Excel project Closed
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 Closed
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 it up...
-
Working on the same workbook from 2 locations Closed
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 vehic...
-
VBA: Delete empty rows based on value of cells Solved/Closed
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: e32 i...
-
Excel linking to word Closed
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 excel...
-
Transfer data from one Excel file to another Closed
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/Closed
Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",...
-
VBA Compare 2 sheets and output difference to 3rd sheet Closed
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 past...
-
Serial numbers Closed
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 is ...
-
How to check if a cell contains "%" and calculate accordingly. Solved/Closed
I am wondering how to do that? I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do.. Ba...
-
FindAll This custom function returns Find and FindNext results as an array of va Closed
Find All This custom function returns Find and FindNext results as an array of values. It will find all the instances of a string (sText As String) a...
-
VBA Stops Running When it Reaches a Blank Cell Closed
Hello Everyone, I have an Excel spreadsheet that I am preparing for use. In the spreadsheet, i have a VBA macro set up to transfer out data from t...
-
VBA Copy/Paste fixed range a number of times Solved/Closed
Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr ex...
-
Excel - IF function with multiple words Solved/Closed
Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the wo...
-
Calcul de prévision des livraisons de colis sur les deux prochaines années Closed
Bonsoir, J aimerai faire une projection sur Excel pour les 2 prochaines années,pour ce faire je dispose des données des livraisons de colis pour 2027...
-
Mac: Copy rows to Master sheet based on cell condition Closed
I am an insolvency professional. I keep details of processes to be conducted on different companies alongwith their time lines. The different columns ...
-
adjust code show message about brand Closed
hi i would helping to adjust my code i have data in my sheet a,b ,c columns a= item , b= brand, c= quantity and userform textbox1,2,3 when...
-
Mac: Copying row of data that contains dates between two specified dates. Closed
Hello Friends, I am reasonably good at excel but have never used macros or VBA. I have multiple workbooks one for each company which has similarly...
-
Find a date in a range of dates Solved/Closed
Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an excel sp...
-
how to merge bank statement into one column Closed
Hello, how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should be i...
