Excel Forum
-
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 ...
-
Compare two spreadsheets to return a single value Closed
Hello, I'm comparing two spreadsheets and I want to see if items appears on both spreadsheets. I've tried index match but I none of my columns hav...
-
Only partial return of search for copy and paste rows Closed
Hello, I have a workbook with multiple worksheets with same format that has data in A4:K15 that I would like to search by any field and have the r...
-
copy paste cells to another sheet when criteria met Closed
Hello, I'm new to Macros and can't figure this one out. The data (numbers) read top to bottom, left to right, row by row. Some of the cells are h...
-
Activate Cells after Data Entry @A1 or Cell 1 Closed
Hello Guys, Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input cha...
-
VBA Color cell in workbook based on value in other workbook Closed
Hello everyone I needed a little help with a VBA macro. I have multiple sheets with data and I was wondering if a Macro could be written to pick up...
-
VBA Macro Help Closed
So i have multiple sheets with data and i was wondering if a Macro could be written to pick up values from one excel file and color the cell in anothe...
-
Create Macro to insert the editor's name, date and time Closed
Hello, I would like seek some advise from expert to do the following: To create a macro box in excel. While I click on the box, the specific ce...
-
Search workbook and copy row results to worksheet Closed
Hi, brand new to the site, but saw multiple posts that seem very close to what I am looking for. I have a workbook with 31 sheets that contain info i...
-
If a cell A contains X then display cell B value Closed
Hello, 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 blank or ...
-
Macro for the sheet where the master details are available. Closed
Hello, Configuration: Windows 7 / Firefox 44.0 I would like to know how to create a Macro for the sheet where the master details are availa...
-
Checking Spreadssheet against Raw Data Closed
Hello, I'm fairly new here. Let me thank you for your input in advance. I've created a master workbook with spreadsheets of the different system...
-
If cell equals text, then value/Formula Closed
Hello, BACKGROUND: I am working on a budget and I'm paying down debt using a waterfall. I have a list of debts on a "Data Entry" tab, and I have ...