Forum
-
Find out date filling cells
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...
-
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...
-
Populate data from a column in one worksheet to a cell in multiple other sheets
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...
-
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...
-
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...
-
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...
-
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...
-
FindAll This custom function returns Find and FindNext results as an array of va
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...
-
VBA Stops Running When it Reaches a Blank Cell
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...
-
Transfer data from one excel file to another excel file
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?
-
VBA Copy/Paste fixed range a number of times [Solved]
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...
-
error in merge two table from two sheets to another sheet
hello, i have 3 sheets sheet 1,2 are 2 tables contains data and merge theses tables in sheet3 it shows me the error ...
-
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...
-
Calcul de prévision des livraisons de colis sur les deux prochaines années
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...
-
Mac: Copy rows to Master sheet based on cell condition
I am an insolvency professional. I keep details of processes to be conducted on different companies alongwith their time lines. The different...
-
adjust code show message about brand
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...
-
Mac: Copying row of data that contains dates between two specified dates.
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...
-
Find a date in a range of dates [Solved]
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...
-
I want to add subjects to this report card
Hello, I am having trouble adding subjects to this excel report card template. I need to add 5 more subjects...
-
how to merge bank statement into one column
Hello, how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should...
-
Excel VBA Sorting Problem
Hello, This code is placing all the header names in the last row after sorting in descending order. Can you please help how to keep the position...
-
Spell number in Excel
Hello, thanks for your coding when i use your coding to convert the number in to Text it will shown as like this for 12 (Rupees...
-
Copy data to a master sheet from newly created sheet
Hello, I have a master sheet that I want to automatically fill. I have a macro that creates a new sheet for each instance, I now need another...
-
Creating Graph that updates
Hello, I am keeping track of how many work orders are being created each month. On my "Completed Sheet" in column F it has the due dates. I...
-
VBA SUM DATA between 2 sheets
hi, expert i have sheet1 contain data from range a4:e and the sheet2 contains data from range a3:g i would sum the data in sheet1 from b4:e...
-
Need to extract the data from one page to another page based on the unique numbe
Hi i have data like below mentioned format, need to extract and paste it in another sheet, please help me in...
-
VBA Coding
I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1...
-
Arrow keys not working
Hello, my arrow keys are not working. up down left right System Configuration: Windows / Edge 16.16299
-
Unable to change date format in Excel [Solved/Closed]
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I...
-
Excel 2013 to extract text in one cell
Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to...
-
how to transfer data from sheet to sheet 2
Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that...
-
IF statement [Solved]
Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion...
-
Dynamically Assign a Number in Data Set
Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can...
-
transfer data from userform to sheet with the same format of table
hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in...
-
How to find the latest time per name in a table with names and times [Solved]
Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have...
-
Need to create linked sheets
Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is...
-
SUMPRODUCT Based on WBS
-
INTEREST ON TERM LOAN AND WORKING CAPITAL [Solved/Closed]
Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to...
DON'T MISS
- Sign Up for a Free Netflix Trial
- How to Download Instagram Videos
- Credit Score
- GTA Vice City Cheat Codes
- How to Block Private Numbers
- Writing Professional Emails in English
- Facebook Confirmation Code Text Not Received
- Reverse Image Search with Google
- Get the Transcript of a YouTube Video
- No Sound from Headphone Jack
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD