Excel Forum
-
contain word, return value [Closed]
Hello, I would like some help. cell a1 contains London - abc cell a2 contains Tokyo - abcd cell a3 contains Singapore - abcde I would like...
-
Entering Formulas for a Master Sheet [Closed]
I want to track who has borrowed materials from a library. I have each resource on a separate sheet with information about the date borrowed, contact ...
-
Macro for creating new workbooks from existing source file(excel [Closed]
Please provide the macro code for the following data source - 1 siddhesh 100000 09/02/1989 2 amol 100000 08/01/1991 3 siddhesh 150000 ...
-
If/then question [Closed]
Hello, If a cell contains any text except for one specific word, I want to return that exact text. If a cell is empty I want to return nothing. ...
-
How to copy and paste entire rows into another worksheet automat [Closed]
Hi! I need to know the code I use to copy and paste entire rows into another worksheet automatically. The conditional value is in column A and row ...
-
Conditional formatting expert needed! Comparing 2 arrays. [Closed]
Hi all, I apologize for the vague title. but I could not think of a way to properly explain the problem in a single line with so few characters... ...
-
Copy paste Rename based on cell value [Solved/Closed]
Hello I have a worksheet named template. I need a VBA code which would copy "template" automatically into a new worksheet and rename the new wor...
-
Copy data from one sheet to a new workbook and save loop [Closed]
Hello, I have a sheet with multiple values which I want to copy into a new workbook, in a certain format, save as a certain name and then repeat f...
-
What function do I use to pull data prior to a certain date? [Closed]
Hello, I have a database that is organized quarterly. I would like to save myself from having to manually move data onto a new sheet after 3 month...
-
Changing date format into a text format [Closed]
Hello, I need to change a date format like 2/1/16 into a text number formatted like this 02/01/2016 or like this 020116? Is there a way to do thi...
-
Auto Fill [Closed]
Hi, May you help me on my excel using vba. I want to use the AUTO FILL function in excel to automatically fill different rows whenever the other row...
-
can not open [Closed]
Hello, excel found unreadable content in 7iBfgO78r.894p do you want to recover the contents of this workbook? please i need solution how to ...
-
Autocopy selected content from 1 sheet to another sheet [Closed]
Hello, I am creating a little database and I have several sheets called "Main", "study1", "study 2" and "study 3' I am only entering data into ...
-
Searching for values and creating a list [Solved/Closed]
Hi there, I hope you can help me, so far I have managed to create a formula which searches a range of data (SKU’s) and returns a count of the occurr...
-
how to save file in different name from folder by macro [Closed]
i want to save a workbook from a worksheet in different folder every time i run a solver a solution is created that workbook file should be saved in...
-
Expenses tables [Closed]
Hello, I am trying to build a table that lets me compare expenses over a period of 6 months in a small area. What I want to do, is input transactio...
-
VBA Assistance - Excel [Closed]
Hi, I could really use some help. I currently run a monthly exercise through excel which is a bit laborious and time consuming due to the volume of...
-
Dtabase Building Copy form master sheet to multiple other sheets [Closed]
Hi, I am after some help. A bit new to Excel and only have basic skills. I am currently setting a database up and need the data on my main workshe...
-
Copy Info From Multiple Worksheets to New Worksheet, No Macro [Closed]
Hello, I need to use conditional formatting/formulas to import cells of a certain value from multiple worksheets, into a new worksheet. I don't th...
-
how to connect db through input from userform [Closed]
Hello, i need to connect to db server with the inputs from the userform. here is the code. Please correct/add if any. user = Val(REPORT.TextBox...
-
Ms Excel match an amount [Closed]
hi, In Ms Excel Work book, I need to match an amount of more than one presented cheqs , which are cleared today, I want to lookup the exact total of...
-
Copying Data/table from one sheet to other [Closed]
Hello, I have copied data from one sheet to another. When I deleted from first sheet this is automatically deleted from seecond sheet Configura...
-
Multi-worksheet recording [Closed]
Hey gang, Long time reader, first time poster. I'm trying to create an excel file to help me stay organized. I know how to pull data from one wor...
-
Error in .SelectedItems during File Picking [Closed]
Hello Guys, I am trying to save a file path in a variable using .SelectedItems but the code is showing "Runtime Error 450". Kindly help me by rec...
-
Name Values [Closed]
Hi I have a sheet of people's names in C8 : C59 and D8 : D59. I would like a formula that can check these ranges and if it sees a specific name it ...
-
Need to seperate data from one cell into multiple. [Closed]
Hello, I want to seperate and pull numbers from a paragraph in one cell. Eg: Temp: 35, rain: 2.56, humidity: 80% I want to seperate into se...
-
Add data from one sheet to multiple sheet [Closed]
Hello, I have one concern that I have to split one sheet data into multiples sheets. Based on condition as below. Main Sheet:"Employeedata" ...
-
how to find value from a column with unique random values [Solved/Closed]
Hello, I need a formula that can get me a value from a column that has unique values and return another cell from that row, can someone help me? e...
-
Creating macros in Excel [Closed]
I need to create a macro in Excel to produce values with two demical places and a dollar sign in the personal macro workbook. I have no idea how to d...
-
Moving a row in Excel [Closed]
Hello, I need to move a row completely from spreadsheet 1 to Spreadsheet 2, which has same rows and columns. Can anyone explain me step-by- step a...
-
Macro for Extracting row information into a new tab [Closed]
Hello I am in need of a macro that will find a name in one column and copy the entire row into a new tab on the same work book. Ex. For every ...
-
Generating and logging jobsheets [Closed]
Hi, Is there a way of worksheets being generated by end users (for example, workers filling in a worksheet which generates the worksheet number seq...
-
ranking [Closed]
Hello, Suppose 5 students mark distribition is given bellow CODE STUDENT NAME SUBJECT: ENG 1 BAN 2 G.MATH ENG 2 TOTAL ...
-
Cell borders will not print, colour fill does not work. [Closed]
Hello, I wonder if anyone out there can help, since upgrading (?) to Windows 10, cell borders do not print and the cell colour fill does not work. I a...
-
Auto Generate workwheet from a list and from a template workshee [Solved/Closed]
Hello All, At the moment, I found out how to auto generate worksheet from a list. However, the generated ones are blank worksheets. May I ask ho...
-
No cell borders or text colour in Excel [Closed]
Since upgrading (?) to Windows 10, cell borders do not print. I also cannot change the text colour. Spreadsheets built before the update also have ...
-
Excel - A macro to rename existing worksheets based on a list [Solved/Closed]
I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just renumber ...
-
Inserting a picture with Path name in a Variable [Closed]
Hello Guys, I am getting an "Error 1004: unable to get insert property of Picture class" with the following code. Looking forward for your guidan...
-
Inserting image in a particular cell in VBA [Solved/Closed]
Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this...
-
macro doubts [Closed]
Hello, How to create new excel worksheet in a same workbook and names of sheets should be same like form1,form2,form3....... Configuration: W...
-
merge cell [Closed]
Hello, What if the compared cell is a merged cell. Example, comparing the values in column C with the merged cell values in Column A, expectin...
-
Exel formulas [Closed]
Hello, To find position class of the student in Mark card
-
A Macro to Create New Workbook and Paste Values Only [Closed]
Hello, I have a workbook with three tabs. I would like to create a macro for a command button that will create a duplicate workbook named "Current...
-
Autoploting (Master to other sheets) [Closed]
Hello, I have a master file for all the transactions in one financial year. This file currently has 4 sheets: EGC,SSM,RSL,MF. The first three are...
-
Macro - new sheet per name list and add template in each sheet [Closed]
Hi all, I'm a new comer here, but looking forwards to learning and helping others!. I am trying to create a macro that will: 1. create a new s...
-
IF statements with dates and criteria [Solved/Closed]
Hello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set of En...
-
Picture issues [Closed]
Hello, I am trying to add a picture to an inventory list. It is made to just write the item code and the details would be generated into other field...
-
merge column [Closed]
Hello, Hello, Example, comparing the values in column C with the merged cell values in Column A, expecting the result of the values from col...
-
Date, time (if the box says YES) next to someone's name [Closed]
Hello, Is there a way for me to have the Date, time (if the box says YES) next to someone's name? http://imgur.com/a/SYpcV For example if s...
-
Help with Excel Formula [Closed]
Hello, I am a beginner at Excel. Trying to figure out formula for: IF DATE in column A is greater than DATE in column B, highlight. Configur...
Subscribe To Our Newsletter!
