Excel Forum
-
Macro to move data from one workbook to other workbook Closed
Hi, I am working on two different workbooks, one of them is a scorecard and the other is the data entry workbook, I am trying to copy a lot of cell...
-
Copy cells to new sheet to create order form Closed
I am trying to write code that will allow me to place an "X" in column A. In response I would like the cells in that line (B:E) to be copied into the...
-
Comparing columns and returning value Solved/Closed
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
-
Compare two sheets in Excel Closed
Hello, First, thank you for taking the time to help me understand how to execute this comparison. I have an excel file with two sheets. I need ...
-
Transfer multiple excel data from cells and moving to another wo Closed
Hello, I would kindly appreciate your help in getting an answer to my question, which is, I have used "Find & Select," specifically Find & Replace...
-
Using Find & Select Closed
Hello, I have used "Find & Select," specifically Find & Replace dialogue box to find specific values/data and then REMOVE, CUT, and Move to anothe...
-
Data in Hot Key Closed
I want to put an email address in a hot key so I don't need to type it ever time.
-
how do i calculate VAT inclusive Closed
Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...
-
macro automatic numbering of invoices combined with letters Closed
I want to know how to perform a macro for automatic invoice number combined with letters at the beginning for example XZY0001
-
Excel Logic Closed
Hello, when i input R in cell, it shows a tex "ok" Or "Not Ok" in another cell
-
Split single excel worksheet into multiple worksheets Closed
While I see many VB solutions 'almost' there, I don't see a solution for me. Challenge is I have client data where each set of data has 'Patient Code...
-
Conditional Formatting Closed
Hello everyone, I'm trying to compare a table from one sheet to one on another sheet, and was wondering if its possible to copy the conditional forma...
-
Change of date Closed
Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...
-
Import .pdf ...? Solved/Closed
Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
-
Use of macro for copy,Edit and Then Paste. Closed
Dear All, I have a set of data covering 9 columns and 62 rows. (A1:I62). Now I want whole data of column 6 (F) to be changed to another data and so...
-
Comparing two spreadsheets using a third for comparison Closed
Hi, I have two spreadsheets with same columns from different sources. I'm trying to use a 3rd spreadsheet to compare the two & show me any diffs. I...
-
arrow keys are not working Closed
Hello, Arrow keys are not working in my laptop. System Configuration: Windows / Chrome 57.0.2987.133
-
Comparison Closed
Hello, I want to create an excel sheet for data entery. There will be a two cases. Case-1:- The value of one cell is equal to value of another ...
-
Autopopulating multiple sheets from one main sheet Closed
Hello, I'm making an quote workbook for an organization and I've run into a problem. On the first sheet "Main sheet" I input all of the transa...
-
Highlight date range if cell containing date falls within that range Closed
Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....
-
freezing column and row Closed
Hello, how do you freeze first column and top row in excel?
-
how to transfer file Closed
Good morning Everyone, I have a Purchase Request list and l wanted to copy a data to one worksheet to another automatically once it's approved in ...
-
Change a cell content according with the color of another cell Closed
Hello, I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE. After digging around wit...
-
Pasting and deleting macro Closed
Hello, I need to create a macro that paste macro buttons from one spread sheet to another spread sheet, but when I try to do this and assign the mac...
-
Nestle fomula nightmare!! Closed
Sorry - fixing mini typo Hello - any help!! Going bald ripping hair out trying to resolve! I want to return a value "Q1" if a date falls between...
-
Need help on Excel macro Closed
I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2' for example, i have a table in s...
-
Highlight date range if date occurs within that range Closed
I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell. How do I accom...
-
EDATE in excel help Closed
Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates ...
-
Excel for Mac date formatting Closed
Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...
-
Format excel data Closed
Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...
-
Copy rows from one tab to another - if specific criteria in col Closed
Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...
-
EDATE Closed
I have a training for log for a large number of staff for various different courses which have all been completed at various different dates and I wan...
-
auto populate data from one sheet to a second Closed
I am trying to have the information entered in the first 2 columns on sheet 1 transfer to sheet 2 in the same location automatically. There are appro...
-
Formula Solved/Closed
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
-
Transferring Data from Multiple sheets to one Closed
Hello, Disclaimer: I am new to macros and VBA, so reading the code is difficult, but I am making it a priority to learn. My problem. I track co...
-
Use Excel Template as a Sign In Form Closed
Hello, I wanted to use an excel file as a sign in sheet. I need user to read the agreement that is presented on screen in an excel file. After read...
-
HELP FOR TIME REMINDER IN EXCEL Closed
Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...
-
Graduate number in a cell Closed
Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...
-
Conditonal Formating Closed
I have a training spread sheet that is used to track the due date of the training for our field personnel. We also use it to determine if the trainin...
-
software for finanicial Closed
how can i get a software for account system tally ,quickbook
-
countif coloring of cells that were used. Closed
Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...
-
copying data from multiple workbooks Closed
Dear all, Greetings of the day..!!! I m looking for a macro for the below requirement. There are multiple workbooks in a Folder, all workbook...
-
I cant get rid of the false function Closed
Hello, I don't know whats wrong with this formula =IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4))) It keeps saying false in the ce...
-
copy data from multiple workbook in one new workbook. Closed
Hello, I have 10 workbooks and have data on Sheet 2 with same Title from Column "B2:N2". All workbooks are in one folder. I want to create a ma...
-
Automatically copy contents from multiple shts to a summary sht. Closed
Hello, I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all ...
-
date in words Closed
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or...
-
Excel-copy data in single sheet & populate multiple sheet by PO Closed
I'm in need of some guidance: Excel- I have one Master sheet with numerous Purchase Order # with multiple products associated with PO#. We want to sep...
-
Move dated cells up to the top of a list Closed
Hello, I have a spreadsheet that I am using for calibration dates. I'm using the traffic light layout for the cells. I would like to know how to...
-
Compare data pairs Closed
I do not know if it can be done using excell formuals, but i have a task: i have a table of 3 columns and about 15000 rows of data. I'd like to find...
-
Trying to propagate the status of a project Closed
Hello! I need help with a timeline project I am working on. I am pretty basic in excel, but can follow instructions and usually fumble my way to succe...
