Excel Forum
-
Using an IF statement to compare dates [Closed]
Hello, I'm trying to compare two dates by referencing two cells. I tried something like this IF(B2>C2, "past due", "on time"). I know to ...
-
How to have my results in different sheets in one workbook? [Closed]
Good day I trust you are well? I was hoping you can assist me with the following and will be most grateful for any help I can get: I have to cr...
-
How to invoke VLookUp function in Excel VBA. [Closed]
Hello, Please, I need a visual basic code that can actually invoke or call a V Lookup function in Excel to query data in two separate worksheets an...
-
Recording Macro To Duplicate Page And Rename To Numeric Value [Solved/Closed]
Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...
-
Need to find a data in a column and copy below cell data or add [Solved/Closed]
Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................
-
Compare 2 worksheets and update one of them [Closed]
I am a beginner Excel user and I hope I can get some help here. I am about to purchase a retail business. I have a copy of the master inventory list. ...
-
Help needed on saving then clearing content except selected rows [Closed]
Hi I am writing a spreadsheet for my ward for TCI list which has admissions, discharges and transfers. I want to be able to save then clear the c...
-
Autopopulating data from one main sheet to multiple sheets [Closed]
Hello, I'm making a workbook for my coworkers to easily know what specific person they need to work with from month to month. I have created a "Mast...
-
Transfer data from multiple sheets to one sheet. [Closed]
Hi all, I'm kind of new to spreadsheets. I have 3 sheets each with the same columns. Column 1 has a type and column 2 has serial numbers, column 3 has...
-
comparing columns in excel - can't remember?? [Closed]
I used to do this function years ago and can't remember how now! I have three columns and each contains a value similar to A001187. I want to compa...
-
Compare workbooks [Closed]
I have a two column workbook. Column 1 is a part number and column 2 is a description. I generate a second workbook with hundreds of numbers and u...
-
count days in excel [Solved/Closed]
Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...
-
Excel Macro [Closed]
I am looking for help in writing a macro to highlight duplicate number in two separate rows. The conditional formatting is really close to what I nee...
-
Excel- How do I auto transfer rows of data to another worksheet [Closed]
Hello all, I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival sco...
-
combine of column [Solved/Closed]
Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.
-
add data on 2 tables at once but in table2 only if text match [Closed]
Hello Excel experts. I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data...
-
Compare values in two columns and return the value from third [Closed]
Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need t...
-
Comparing two excel worksheets [Solved/Closed]
please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...
-
Populate 2 tables at once but one table only if text match [Closed]
Hello, I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data it's entere...
-
userform populate combobox2 based on combobox1 selection [Closed]
Hello, I have a userform with 2 comboboxes both work fine and they both get the items to select from the same column they each populate pulling uniq...
-
Date function [Closed]
Hello, I'm using a function =date(year(j2)+(m2),month(j2),day(j2)) BUT.. I want to be able to type in words like NIL, NO, and DEFER in to cell M2...
-
need to find a data in a column and copy below cell data or add [Closed]
column A column B column c 1......................... .........2 2.............. 23 3 2............... 25 5 want to use a excel function...
-
Error [Closed]
Hello, I have written macro which have sheets 6 and when file which i get have sheet 2 only,when i run maco on file having sheet two i get error a...
-
Accounting [Closed]
How do I create client data base for my small business
-
Carry forward formula [Closed]
Hello, I'm trying to find if there is any formula to carry forward a figure to another spreadsheet on a daily basis. the cells were not at the sam...
-
Drop Down List and Auto copy data based on date in cell to anoth [Closed]
Hello, I need help fast. I'm not the resident expert my boss think I am apparently. Excel 2010. I imported info from a Word Perfect document whi...
-
VBA Tricky Question [Closed]
Hi All, I am working on excel and I need some help with VBA/macros. Basically, I have a variable called Y and I have a table of set values, call...
-
Compare two csv files [Closed]
Hello, I have two csv files which has member details. I just have to compare both the files and confirm if its similar. Any way to do it through e...
-
printing numerous copies [Closed]
Hello, I have a seguential numbering macro that numbers a 2 part EWO - I want to be able to run more than 1 set at a time - how do I do that? C...
-
Sending Data from one spreadsheet to multiple speadsheets [Closed]
Hello, I am fairly new to VBA and have been searching for a solution for my problem but as yet have not managed to find one. I wish to send da...
-
Save data to different sheet by clicking a button (LibreOffice) [Closed]
Hi Everyone, I have a attendance record sheet that employees enter in the hours they worked each day for that pay period, which is a two week perio...
-
conditonal format a because of values in another cell [Solved/Closed]
Hello, i am trying to figure out how i can format a cell to show green when above a figure and red when below the figure simple i know but here co...
-
cursor in excel does not work [Closed]
I use Window 7 and Office 2010 with license. I bought in Bangkok, Thailand. This morning my cursor in excel has been changed from arrow to be thick...
-
Arrow cursor has been changed to Cross and cannot move any cell [Closed]
Hello, Please help me, I cannot use cursor in excel to move cell or drag. Thanks & Regards, Configuration: Windows 7 / Mozilla 11.0
-
Function Formula Date and Text [Solved/Closed]
Good day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl frm 1...
-
SPELLNUMBER VBA IN EXCEL [Solved/Closed]
Hello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation =SpellNumber(1,100,000) =...
-
Conditional Formatting for 2 columns [Closed]
Hi I am currently using conditional formatting on cells with dates, I have used cell value rules to highlight a pending date within 14 days and one...
-
If a cell A contains X then display cell B value - Please advise [Closed]
Hello Everyone, How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column b...
-
Excel question [Closed]
I have an excel spreadsheet that I enter data on all month. At the end of the month I must extract that data and break it down into totals and put it ...
-
How to change Oct 26,2015 to 26-10-15 [Closed]
Hello, Can any one help me to change Oct 26,2015 to 26-10-15 in a excel cell. Configuration: Windows 7 / Firefox 44.0
-
Conditional formatting on an entire row [Solved/Closed]
Hello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12
-
Issue with Date and Text in if formula [Closed]
Hello, I'm trying to write a function for a cell which refers to different descriptions in one column - where it only should combine some descript...
-
Receiving an error message for VBA [Closed]
Hello, I was given a workbook to fix with 5 different sheets. The Summary sheet has a button to "Refresh Equipment List" which is supposed to ...
-
How to sum row color [Closed]
Hello, Please help us with how to sum numbers marked in different colors. Configuration: Windows 7 / Chrome 48.0.2564.116
-
simple way in Excel to copy data [Closed]
Greetings, Can anyone help me. I am working on a huge project and looking for a simple way in Excel to copy data. If I have a master document w...
-
Copy rows from sheet 1 to sheet 2 if rule is met [Solved/Closed]
Hi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...
-
VSB error autogenerate worksheet from list [Closed]
Hello, So I have an excel that has mutiple worksheets "2016 Census" "Tracker Template" What I did was use a code to automatically pull data f...
-
how do io open 2 different excel sheets simultaneously [Closed]
Hello, How do I open 2 different excel sheets simultaneously. Thanks
-
How to sort product by keyword in description then add a prefix [Closed]
Hello, I have thousands of products that I have to sort by category then assign a number prefix to its item ID. I was wondering if there was a way...
-
adding a value to a cell that contains text [Closed]
Hello, Can someone please help me? I want my cell to have the word FREE written in it BUT I also want that cell to represent 0.00$ when I add it to ...
