Excel Forum
-
Avoiding excel cropping text when next cell contains formula [Closed]
Hello, If you have empty cells to the right, text from a cell will float over the columns following. However, if you have a formula placing "empty...
-
to check first letters of two columns are equal [Closed]
Hello, could you please tell me how to check whether first letters of two columns are equal
-
how to auto copy [Closed]
Hello, My workbook contains about 1000 sales entries on sheet 1 . Some customers paid in full, but some other don`t. I will put a * beside the cus...
-
What Type does it want? (VBA question) [Solved/Closed]
Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...
-
comparing two columns [Closed]
I have two columns both of which contain list of names.i want to get the output as true if the names are somewhat similar eg dane john and dwayne john...
-
Auto Hide Rows & Columns [Closed]
Hello, i have a worksheet with many formulas in it. i use bellow code for auto hide rows and columns when a a cell in that column or row is 0 or e...
-
copy info from one excel sheet to another sheet [Closed]
I have sheet 1 that i call "FORM" that I enter information into. I would like to create a macro to copy the info that i put on the FORM onto sheet 2 "...
-
Excel Macro to Create a Workbook for Each Change in Column A [Closed]
Hello everyone. I love forums like this where the community helps one another and solve real life problems faced by real users. I would very much ...
-
fix the last date [Closed]
Hello, my target is 3900 but daily target is 50, how to fix last date for closing of my target. please define formula with examples Configurati...
-
Conditional formatting??? [Closed]
Hello, If I enter 1 in a particular cell, I want that cell and the next cell in the row changes to certain colour fill (ex. G5=1, then G5, H5)... ...
-
VBA programming, copy wks from one file to another [Closed]
Hi, I am struggling with the code to copy each sheet in workbook1 to workbook2) Dim NewWorkbook As Workbook Dim Wks As Worksheet Dim wb1 As Work...
-
Conditional Formatting to hide 00:00 in column [Solved/Closed]
Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...
-
coping & pasting data in first blank cell in same worksheet [Closed]
Hello, I would like the vba code for a macro ( using a form button) that copies data from cell:M1 to A13:A30 depending on which is the first blan...
-
Conditional Formatting based on Checkbox [Closed]
Hi, I've been trying to conditionally format a merged cell by what happens to a checkbox. If my checkbox is blank and the control cell in B16 is "...
-
help me on this formula to shorten [Solved/Closed]
Hello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can sho...
-
conditional format problem [Closed]
I have 3 columns Column A start time (hh:mm) Column B finish time (hh:mm) Column C is total Time (hh:mm) where C is (24-A1)+B1 etc How can I hide the...
-
How to copy data from one spreadsheet to all others [Closed]
Please, does anyone have a macro to copy data from a specific range on a standard sheet (ideally with formatting) to all but one other sheet active in...
-
Copy data based upon cell value [Closed]
Hello, Need help on copying data from file1.xlsx into multiple .xlsx file based upon column G values. The file1.xlsx contains... Column F Column...
-
Macro to insert pictures using 2011 excell [Closed]
Hello, im trying to make a prototype for a POS that insert images into the invoicing system. for the most part i have this functional, but the boss ...
-
Excel Macro for copy row to another workbook. [Closed]
Hello, New-ish to excel and I'm helping improve systems at the work place. The issue is I want to be able to copy a row. e.g. | New | 12345...
-
Transpose Column to Row [Closed]
Hi All, I have list of data need to transpose as below. Anyone can help with the macro? Thank you. From Material Des ww1 ww2 A Q 1 4 B E 2 ...
-
Excel Picture Inserting Macro Help - Urgent [Solved/Closed]
Dear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro which ta...
-
date formats [Closed]
Hello, friends... i have problem in the date formats i have an excel sheet with data i am trying to filter by date 01/12/1999 this is the dat...
-
Create a formula in excel to scan workbook and move to new one [Closed]
I want to know how to create a formula that scans all of column A only for duplicate data and if found than in a new worksheet copy the entire first r...
-
Conditional Formatting on Excel 2010 [Closed]
Hi, I am trying to figure out the correct method in which to apply a formula in conditional formatting. The first row contain the document names....
-
how autofill data from sheet1 to sheet2 in different order. [Closed]
When we type numbers in any sequence in sheet1 but they out come countinusely in sorting sequence in sheet2
-
Populating a column of data based on drop down selection [Closed]
Hello, I am trying to populate a column with data from a seperate sheet based on a selection from a drop-down list. The drop list and the desire...
-
Making a table based on cell value. hide row. conditional format [Closed]
Hello, This is for a machinery quotation, based on model type and specifications I have a sheet in which cell B2 has a drop down menu listing 4...
-
Multi percentage Calculation [Closed]
Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I attac...
-
If dates range [Closed]
Hello, I need help for a function. Lets say that we have the today date 4/12/2014. I need a formula to use in conditional formatting. If the da...
-
How to count different charecters [Solved/Closed]
Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa...
-
Date if statments [Closed]
Hello, I have a if statement that I need help writing. I have a today date cell and I have closed date. I am trying to make the new cell check i...
-
Check if input number is minimum and display a pop up dialogue [Closed]
Hi, I am novice VBA developer. I am trying to write a macro which does following. 1.When a user enter a particular value into cell 2.Check if ...
-
change date format [Closed]
Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007
-
for progress billing [Closed]
Hello, how can i automatically know the percentage area of a accomplished tiles by simply counting the tiles Configuration: Windows / Chrome 3...
-
compare two excel sheets and get unique value from both into new [Closed]
Hi, I have two excel sheets. Sheet 1 with 4 columns and sheet 2 with 2 columns. I need to compare column 1 of sheet1 with column 1 of sheet 2 if it m...
-
How can I transfer data from one spread sheet to another? [Solved/Closed]
Hi, I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data ...
-
Finding data in different Excel sheets with month-sort by VBA? [Closed]
Hello, I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a tabl...
-
automatically moving rows from sheet 1 to sheet 2 [Closed]
My document has several sheets, but what I'd like to do is create a VBA to automatically move a row to sheet 1 from sheet 2 when I have selected 'Acti...
-
Repair Corrupt Excel File [Closed]
I have an excel 2003 workbook that will not open. The file is huge. I have tried the repair utility within Excel but it still will not open. Has an...
-
Data validation [Closed]
I want a sheet of income tax calculation, so i like a input a cell pan no. so allow in cell LENTH 10 DIGIT AND first five text and mid four number and...
-
2 macros in one sheet targeting same cells [Solved/Closed]
This is probably a really 'newbie' question but in all honesty, I'm new to macros and need some assistance. I have a macro written to automatically...
-
Lock Flag ignored:How is this possible? [Closed]
Hello, Cells C4 and D4 are empty cells, and both are locked in Format Cells->Protection-> Locked. I go to Tools-> Protection-> Protect Workshee...
-
Help me on this formula to shorten [Closed]
Hello, please help me out to shorten this formula.. =IF(B53="SP1",2,IF(B53="SP2",2,IF(B53="SP3",2,IF(B53="SP4",2,IF(B53="SP5",2,0)))))+IF(B54="...
-
How can we find data in different Excel sheets by VBA? [Solved/Closed]
Hi.I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table wit...
-
Create a new sheet using data in one column copying data [Closed]
Does any one know how to create a macro which takes the following data: A B C D 1 Rabbit Carro...
-
Copy rows from activesheet and create and paste in new sheet. [Closed]
Hey guys I have a workbook with +-5000 rows of rooms in different buildings. I want use the column BUILDING_CODE and copy all the rooms that have ...
-
Copy template .xlsx file based upon unique cell values [Closed]
Dear All, Need you help for copying template .xlsx files based upon the unique cell values present in another excel file called file1.xlsx-->values i...
-
Conditional formating to check text in another shell + numeric [Solved/Closed]
I have some text in A column ( say xxx, yyy) and numeric value in Column B . Now i want to highlight the shell in column B with 4 condition . 1....
-
customize multiple workbooks [Closed]
I am currently working on attempting to consolidate excel workbooks in that I am looking for a way to input in one workbook and have it transfer to 2 ...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- How to Install a VPN
- Computer Boots to Black Screen