Excel Forum
-
Change cell color based on another column Solved/Closed
Hi All, I am not very good at excel, however I am looking for a solution for the following problem. There are two columns (Column A and Column B...
-
Default ´Value in a Cell for User to fill it Closed
Hello Guys, I would like to know if there is a way to input a default value in a cell so that it can indicate the user about the information to ...
-
Underlining a Value in a Variable Closed
Hello Guys, I have a variable which contains some value. I would like to underline it before printing it into a cell. I have used the following lin...
-
Incorporating the text formating when Formula in used Closed
Hello Guys, In Cell A1, the text is "abc" (Note that "abc" is underlined). If i choose cell B1 and apply a formula as "=A1", the cell B1 shows "ab...
-
Concatenating a variable.formula and variable.value Closed
Hello Guys, I would like to know if there is a way to concatenate a variable.formula and variable.value. I have written the following lines of...
-
Transfer data between excel sheets Closed
Hello. I have converted pdf files into excel. So each pdf file presents sheets in a single workbook. Now the issue is I have around 100 sheets. But...
-
Best resources to learn about PowerPivot? Solved/Closed
Hello, I'm expected to use PowerPivot extensively - meaning with complex data models. What would you recommand for a newbie who wants to learn?
-
cond format for date column Closed
Hello, I am trying to apply cond. format to a date colunm to change color according to todays date +30, +60, and +90...all being different color fi...
-
in some cells dates format are changed Closed
Hello, the prblem is that when i upgraded to office 10 then formate of dates are changed in some cells of the worksheets and whn i changed the forma...
-
Excel vba to work on ALL workbooks - please help. Closed
Dear valuable members, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cell...
-
Excel vba to work on ALL workbooks Closed
Hello, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cells(Rows.Cou...
-
Find variable and paste name of sheet in another workbook Closed
hello, i need to search a variable in an existing workbook and then copy the name of the sheet in which it si contained and paste it against the varia...
-
transfer specific data on to a second work sheet Closed
WORKBOOK 1 Services ALL - contains columns A-F (a- Qtr, b-Locality, c-Date, d- first name, e- surname, f- Comments) I have a WORKBOOK 2 with work...
-
covert the date format into text in excel Closed
How to convert birthdate in text format in excel
-
Append & Copy Data Automatically from Tab A to Tab B Closed
I'm trying to automatically append any new data from one excel tab (ReportExport) to another tab (MappingTool) if the vlookup on the MappingTool tab i...
-
Wildcards or values in a macro? Closed
Hello, I created a macro (by recording) that looks at the names and picks them based on the full name. Is there a way to just use a wildcard? Instea...
-
How To Make an Excel Sheet Equal to Another Solved/Closed
Hi, I'm new in Excel, and what I'm trying to do is this: I want to make an entire sheet equal to another, except for one cell, so if I change somethi...
-
Macro to copy a sheet to a new sheet after a filter and sort Closed
Hello, I have a recorded macro that picks specific values in a list and sorts them to display only ones with those values. What I would like to do ...
-
Macro to change the find option from 'workbook' to 'sheet' Closed
I cannot find a macro anywhere to change the find option from 'workbook' to 'sheet'? Any help greatly appreciated.
-
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 ...