Excel Forum
-
Compare 2 columns on different sheets and move data when match [Closed]
Hello, I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one workshe...
-
Copying An Entire List of Formulas into another Work Sheet [Closed]
Hello, I have a list of sumif statements that I would like to copy from one excelsheet to another. Can this be done all at once, without changing ...
-
Caculating the number of months between a set of dates [Closed]
Hi, I am trying to calculate the number of months between two dates that relates to a specific time frame (financial year). Is anyone able to su...
-
Auto Generate Dates [Closed]
Hi All, I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only we...
-
Summery Sheets [Closed]
Dear All, I am maintaining a File in Excel for Employee's Vacation and every year has a different file. In this file I am adding a new Sheet by the...
-
Auto generation of code [Solved/Closed]
Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...
-
what is the Numbe shoud be instead of ?? [Closed]
what is the Numbe shoud be instead of ?? My Values fixed No Results 70064 ?? -11 1721118038 ?? ...
-
Need macro to copy certain data from a form on one tab to a log [Closed]
Hello, Trying to copy data from a form on one tab to a log/data list on another tab and advance to the next line on the log for the next user ...
-
VBA Coding to copy data from one worksheet to another worksheet [Closed]
Hello, I would like to know how to use vba coding to automatically copy data from one worksheet to another worksheet based on a specific criteria an...
-
filter between 2 dates [Closed]
Hello, please i want to filter data between 2 dates (start date and end date) with textbox and button command, i am new to programming in vba; plea...
-
How to use VBA Macros in excel 2016 [Closed]
Hi, Need a bit help for now. I am going to make transmittal that has two sheets which includes input(data) and output(transmittal). This will be my tr...
-
Excel - A macro to create new workbook and copy data [Solved/Closed]
In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...
-
How to populate sub sheets based on criteria from a master [Closed]
Hello, I'm working on a master file with sub sheets. I'd like to auto populate data from rows A-S to sub sheets (Dave, Jamal, Addi), based on data ...
-
Excel - macro to create multiple sheets [Solved/Closed]
Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...
-
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...
-
Running a macro in different cells [Solved/Closed]
Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
-
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...
