The discussions

Creating a macro that does not copy amount of rows from file

Hello, I am trying to create a macro that does NOT copy the amount of rows in the file the macro was recorded in. For example: The macro is sp...

1 reply Last reply on 8 Sep 2015 by
TrowaD

Formula for correction

Hello, The date is 12-July-2015 but in Excel the same is showing as 7-Dec-15 please suggest for the correction Configuration: Windows / Chro...

1 reply Last reply on 8 Sep 2015 by
TrowaD

Sumifs function

Hello, I am trying to sort the formula below =SUMIFS(Sheet3!$AI$15:$AY$22,Sheet3!$B$15:$B$22,$A142,Sheet3!$AI$4:$AY$4,D$2) the criteria_rang...

1 reply Last reply on 8 Sep 2015 by
TrowaD

Clicking data in one sheet..saving all those clicked in another.

 Solved

Hello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...

4 replies Last reply on 8 Sep 2015 by
sram

How can i filter data from two work sheets by matching values

Hello, I have two Excel sheets. I want to copy name and address on D and E columns of sheet 1 from sheet 2 if both sex and age match.The first one h...

1 reply Last reply on 7 Sep 2015 by
RayH

Creating new sheet when got into some event

Please help me built macro like this : When i write name at "C7" and pressing Enter Button it will create new Sheet with the C7.Value.And it will d...

4 replies Last reply on 7 Sep 2015 by
TrowaD

Same date in column a on mutiple lines in seperate worksheets

 Solved

Hi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...

3 replies Last reply on 7 Sep 2015 by
TrowaD

Transfering the numbers with some calculations inside

Dear, i want to reformulate some data from an excel sheet to another with other columns titles. the order of the rows are different also. i added ...

1 reply Last reply on 5 Sep 2015 by
smuneeb

Icon sets in excel

 Closed

Hi, How to create icon sets K Column. how to create formula for icon sets ("K" COLUMN). I want Icon sets Green, Yellow, ReD.

1 reply Last reply on 5 Sep 2015 by
vcoolio

Transferring data between sheets using macros

Hello, I am having difficulty getting this to work. My original intention was to use a For Loop with an If check, but here is what I am trying to ...

1 reply Last reply on 5 Sep 2015 by
vcoolio

100-1=99 then 99+1=100

Hello, Good day. I want to ask something because i can't do this on my own. i want to minus D18 - D21 = H20 (100-1=99) ...

1 reply Last reply on 4 Sep 2015 by
ac3mark

Macro to copy data from master worksheet to new sheets

Hello, I hope everybody here are doing fine! Please, if anyone could help me with a macro for one of my Master reports. I don't really know muc...

1 reply Last reply on 3 Sep 2015 by
ruthf8

Change date format in excel 2007

Hello, I want to change date format in excel 2007 as given below please help me. now it is 09/01/2015 but i need (ddd mmm yyy 01/09/2015) like ...

1 reply Last reply on 3 Sep 2015 by
xpcman

Acrobat reader

 Solved

Hello, I get a prompt that my acrobat browser plugin is missing and need to reinstall. Do I need to download the software again? Configuration...

2 replies Last reply on 3 Sep 2015 by
Margaret

Please help in getting data clubbed in one cell

 Solved

Please inform how to get the following information clubbed in a row Data as follows Required data in a ...

3 replies Last reply on 3 Sep 2015 by
TrowaD

Master sheet to work sheet,

 Solved

I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...

29 replies Last reply on 3 Sep 2015 by
vcoolio

Macro to copy data from multiple sheets onto single sheet

Hello, I have multiple sheets that contain basically identical data and I am trying to extract certain parts and place it onto a single sheet. The ...

3 replies Last reply on 3 Sep 2015 by
vcoolio

Vb averaging random fields in excel 2007

Thanks very much for help on this . . After finding a row based on a field value, I need to get the value from a different field in that row . . ....

1 reply Last reply on 2 Sep 2015 by
ac3mark

Using partial text in a field, color the row

Thanks for help on this . . . Using the last 2 characters in a string in field GFi, color that row . . next row Example: for all rows with...

1 reply Last reply on 2 Sep 2015 by
ac3mark

Accounts data requires automatic analysis

 Solved

Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...

2 replies Last reply on 2 Sep 2015 by
249ccjames

How to autogenerate a new daily report

I have a daily report made up in Excel containing daily (manually entered) data, and "to date" (computed in Excel) data. I would like to be able to...

2 replies Last reply on 2 Sep 2015 by
aldeane1

Outlook express

hmm.. I asked a while ago a question about my outlook express .. and someone answered me but actually I didn't understand what to do .. and because hi...

1 reply Last reply on 2 Sep 2015 by
xpcman

How to create auto populating multiple sheets based on cell

Hello, I'm currently creating a building condition assessment form. I would like to know how to create auto populating multiple sheets once I sele...

1 reply Last reply on 1 Sep 2015 by
TrowaD

Custom sorting & calculating average based position

 Solved

please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...

2 replies Last reply on 31 Aug 2015 by
oluwaridenawa

Search word from list, match it copy values next to it

 Solved

I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...

2 replies Last reply on 31 Aug 2015 by
haris1989

Sum value of one column if in another column there is a text

Hello, I am trying to sum values in column A if in column B there is a certain number. So, Column A 10 20 30 40 50 Column B E45D...

1 reply Last reply on 31 Aug 2015 by
Mazzaropi

If cell have specific text it give us alert message

Hello, If cell have specific text it give us alert message Configuration: Windows XP / Chrome 44.0.2403.157

1 reply Last reply on 31 Aug 2015 by
TrowaD

Word 2007 docs in read-only mode

I recently upgraded from Windows 7 to Windows 10. Unknown to me until just the other day, my documents are in read-only mode. I can edit one, create...

8 replies Last reply on 28 Aug 2015 by
ac3mark

Transpose data in single column into 4 columns

Hello, I have data in a single column and would like to transpose it into a row for every 4 rows. I have about 7000 rows in the 1 column. I'd l...

1 reply Last reply on 28 Aug 2015 by
Mazzaropi

Compare 2 columns choose answer in third

Hi all, First of all thank you for reviewing this. I have a data dump from a survey. Column A shows the survey #. On other sheet (sheet1) I have...

1 reply Last reply on 27 Aug 2015 by
xpcman

Macro-copy data from one workbook to another

 Closed

All, I need to copy data from one workbook and append the content to another workbook (WB). Ex: WB1 (source) has 1 2 3 4 5 WB2 (target) al...

12 replies Last reply on 27 Aug 2015 by
Dvibe

A macro to change the values on a specified cell

Hello, I am searching a macro code on excel to set a value on a cell that is found by using such an excel function =ADDRESS(MATCH(N7,'Sheet1'!...

1 reply Last reply on 27 Aug 2015 by
TrowaD

Copying cell information

Hello, I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The informatio...

1 reply Last reply on 27 Aug 2015 by
TrowaD

Using if formula for dates

hello, i want to make a sheet for my job to track the allotments, i want it to count the days allotment sent for signature till it is back from sig...

1 reply Last reply on 26 Aug 2015 by
ac3mark

Data validation if then

Hello, I have a "Yes" or "No" data validation list in cell C1 and manual input cells in D1, E1 etc. I would like to create a code that says (If C1...

1 reply Last reply on 25 Aug 2015 by
xpcman

Search,compare,update,indicate data in excel sheet (macros vba)

Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. Another targeted sheet to be completed with using VBA which content same 10...

2 replies Last reply on 25 Aug 2015 by
MAY7

Help with a school directory

Hi all, I am creating a school directory. My columns are Last Name, First Name, Father/Mother, Phone, Email, Address, Zip, Teacher, Grade. I ha...

1 reply Last reply on 24 Aug 2015 by
xpcman

Urgent,,,custom database from one entry sheet to multiple sheets

Hello, Thank's in advance...for helping in my problem I enter data in a sheet and based on that i print few page report that contains that variable...

1 reply Last reply on 24 Aug 2015 by
xpcman

Enable macro security via macro or automatically

Hello, Dear Friends i m not good in english so sorry in advance for bad english. but i need to enable macro automatically when worksh...

3 replies Last reply on 24 Aug 2015 by
TrowaD

Wireless router password

Hello, I need a password for my router192.168.1-1 at 22356 mcintosh avenue, maple ridge bc. canada papa

3 replies Last reply on 23 Aug 2015 by
hiro

Cant send emails in outlook

Hello, i have a problem sending my emails from Microsoft Outlook 2010. I have to log into my gmail account in order to send emails but I can rece...

2 replies Last reply on 23 Aug 2015 by
ZahidITOG

Transfer data from multiple sheets to sheet 1 based on criteria

Hello, I am creating an estimating workbook where I have multiple product sheets that list qty, part#, description, volume, lbs, list price & disc...

1 reply Last reply on 23 Aug 2015 by
vcoolio

How to open hidden & locked file?

Hello, Good Morning, I was about to click the print option for my Microsoft Word File but I clicked the exactly below option which was "Hide and ...

1 reply Last reply on 22 Aug 2015 by
Ambucias

Concatonating within commands???

 Solved

Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...

4 replies Last reply on 21 Aug 2015 by
BrianGreen

Why the type mismatch error?

My question is in the comment in the code: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Cells.Count > 1...

1 reply Last reply on 21 Aug 2015 by
xpcman

Format row based on text length

Hello guys, Can you pls help me? I am beginner in VBA and I need to sort out one macro. I have table and need to have highlited row with color, bu...

3 replies Last reply on 21 Aug 2015 by
vcoolio

Using if condition with date function

Hello, Sir, i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date col...

3 replies Last reply on 21 Aug 2015 by
vcoolio

Step by step instructions

Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a prompt in...

7 replies Last reply on 21 Aug 2015 by
nnavarro

Get month name and year from date

Hello, how do I can convert the date in to month name and year ex. 01/05/2015 , I want to get month name as May and year 2015 pls help me, b...

1 reply Last reply on 21 Aug 2015 by
vcoolio

Change date automatically on the sheets

Hello, I have a document in Excel, and has 5 different pages; all of them have the date on top. I need to know, how I can set up the formula or th...

3 replies Last reply on 20 Aug 2015 by
Mazzaropi
Results 2801 - 2850 out of a total of 12,258