The discussions

Excel formula query

Hello, If I enter 1 in column A1 I want column C1 to equal the content of column C2 Configuration: iPad / Safari 9.0

1 reply Last reply on 28 Nov 2016 by
Mazzaropi

Transferring data between sheets

Hello, Thanks in advance for reading my question. I am have two excel sheets. The first sheet contains the columns: first name, last name and i...

1 reply Last reply on 28 Nov 2016 by
TrowaD

Coloring line indicated the name, by the table where there is th

Hello, I have four tables with four different colors, are 4 different categories of staff. First with font color blue Second with font color red...

5 replies Last reply on 28 Nov 2016 by
Mazzaropi

Autofill based on filename in same/different folder.

Hello, I'm looking for a way to pretty much automate part of my job, which is creating manhole sheets. In folder there are 10 files, each is calle...

3 replies Last reply on 28 Nov 2016 by
yg_be

Copy query from all worksheets of same workbook

Hello, Please help me with below, I have 600 worksheets file, out of which i want to add only fiest column of all sheets in one master file and th...

1 reply Last reply on 28 Nov 2016 by
yg_be

Conditional formatting based on multiple values

Hello, I want to color my cell if one of few drop down list is picked for example: if appe or orange are getting picked, it needs to color it in gr...

1 reply Last reply on 27 Nov 2016 by
Mazzaropi

Change password

Hello, Pls forget my password Configuration: iPhone / Safari 4.0

1 reply Last reply on 27 Nov 2016 by
Ambucias

Change cell color based on another column

 Solved

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...

5 replies Last reply on 24 Nov 2016 by
Ambucias

Default ´value in a cell for user to fill it

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 ...

1 reply Last reply on 24 Nov 2016 by
yg_be

Underlining a value in a variable

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...

2 replies Last reply on 24 Nov 2016 by
yg_be

Incorporating the text formating when formula in used

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...

1 reply Last reply on 24 Nov 2016 by
yg_be

Concatenating a variable.formula and variable.value

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...

1 reply Last reply on 24 Nov 2016 by
yg_be

Transfer data between excel sheets

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...

1 reply Last reply on 24 Nov 2016 by
TrowaD

Cond format for date column

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...

2 replies Last reply on 24 Nov 2016 by
vinay

In some cells dates format are changed

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...

1 reply Last reply on 23 Nov 2016 by
yg_be

Excel vba to work on all workbooks - please help.

Dear valuable members, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cell...

1 reply Last reply on 23 Nov 2016 by
yg_be

Wildcards or values in a macro?

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...

3 replies Last reply on 22 Nov 2016 by
ac3mark

How to make an excel sheet equal to another

 Solved

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...

5 replies Last reply on 22 Nov 2016 by
Mark Han

Macro to change the find option from 'workbook' to 'sheet'

I cannot find a macro anywhere to change the find option from 'workbook' to 'sheet'? Any help greatly appreciated.

1 reply Last reply on 22 Nov 2016 by
TrowaD

Contain word, return value

Hello, I would like some help. cell a1 contains London - abc cell a2 contains Tokyo - abcd cell a3 contains Singapore - abcde I would like...

3 replies Last reply on 22 Nov 2016 by
TrowaD

Entering formulas for a master sheet

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 ...

3 replies Last reply on 21 Nov 2016 by
vcoolio

Macro for creating new workbooks from existing source file(excel

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 ...

1 reply Last reply on 21 Nov 2016 by
vcoolio

If/then question

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. ...

10 replies Last reply on 21 Nov 2016 by
yg_be

How to copy and paste entire rows into another worksheet automat

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 ...

1 reply Last reply on 21 Nov 2016 by
TrowaD

Conditional formatting expert needed! comparing 2 arrays.

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... ...

3 replies Last reply on 21 Nov 2016 by
TrowaD

Copy paste rename based on cell value

 Solved

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...

7 replies Last reply on 21 Nov 2016 by
Josephnb

Copy data from one sheet to a new workbook and save loop

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...

2 replies Last reply on 21 Nov 2016 by
marks88

What function do i use to pull data prior to a certain date?

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...

2 replies Last reply on 20 Nov 2016 by
fdibbins

Changing date format into a text format

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...

2 replies Last reply on 20 Nov 2016 by
fdibbins

Auto fill

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...

1 reply Last reply on 20 Nov 2016 by
fdibbins

Autocopy selected content from 1 sheet to another sheet

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 ...

14 replies Last reply on 19 Nov 2016 by
vcoolio

Searching for values and creating a list

 Solved

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...

7 replies Last reply on 18 Nov 2016 by
yg_be

Ms access ranking students

Dear All, How can i rank my student in ms access to find thier rank using vb, macro, query, expression builder or code builder which one the easy way...

11 replies Last reply on 18 Nov 2016 by
yg_be

Vba assistance - excel

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...

1 reply Last reply on 17 Nov 2016 by
yg_be

Dtabase building copy form master sheet to multiple other sheets

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...

1 reply Last reply on 17 Nov 2016 by
yg_be

Copy info from multiple worksheets to new worksheet, no macro

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...

1 reply Last reply on 17 Nov 2016 by
yg_be

How to connect db through input from userform

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...

1 reply Last reply on 17 Nov 2016 by
yg_be

Ms excel match an amount

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...

1 reply Last reply on 17 Nov 2016 by
yg_be

Copying data/table from one sheet to other

Hello, I have copied data from one sheet to another. When I deleted from first sheet this is automatically deleted from seecond sheet Configura...

3 replies Last reply on 17 Nov 2016 by
Mazzaropi

Multi-worksheet recording

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...

1 reply Last reply on 17 Nov 2016 by
Mark_Wales

Interest needed

Hello, I am chowdary . I need some info from you. plz give the solution for me what the interest for 1 crore if interest is Rs.1.50ps Configu...

1 reply Last reply on 16 Nov 2016 by
BunoCS

Looking for free ost to pst converter

 Closed

Hello, I am looking for ost to pst converter. Please advise me a good one. Preferably free Any help/advice would be appreciated, Dale

1 reply Last reply on 15 Nov 2016 by
Ambucias

Error in .selecteditems during file picking

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...

1 reply Last reply on 15 Nov 2016 by
yg_be

Name values

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 ...

1 reply Last reply on 15 Nov 2016 by
TrowaD

Need to seperate data from one cell into multiple.

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...

1 reply Last reply on 14 Nov 2016 by
TrowaD

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" ...

1 reply Last reply on 14 Nov 2016 by
vcoolio

How to find value from a column with unique random values

 Solved

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...

4 replies Last reply on 13 Nov 2016 by
student123456

Creating macros in excel

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...

1 reply Last reply on 13 Nov 2016 by
yg_be

Moving a row in excel

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...

5 replies Last reply on 13 Nov 2016 by
yg_be

Macro for extracting row information into a new tab

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 ...

1 reply Last reply on 11 Nov 2016 by
yg_be
Results 1651 - 1700 out of a total of 12,259