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...
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...
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...
Clicking data in one sheet..saving all those clicked in another.
SolvedHello, 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 ...
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...
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...
Same date in column a on mutiple lines in seperate worksheets
SolvedHi, 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...
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 ...
Icon sets in excel
ClosedHi, How to create icon sets K Column. how to create formula for icon sets ("K" COLUMN). I want Icon sets Green, Yellow, ReD.
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 ...
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) ...
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...
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 ...
Acrobat reader
SolvedHello, I get a prompt that my acrobat browser plugin is missing and need to reinstall. Do I need to download the software again? Configuration...
Please help in getting data clubbed in one cell
SolvedPlease inform how to get the following information clubbed in a row Data as follows Required data in a ...
Master sheet to work sheet,
SolvedI 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 ...
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 ...
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 . . ....
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...
Accounts data requires automatic analysis
SolvedFive columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...
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...
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...
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...
Custom sorting & calculating average based position
Solvedplease 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...
Search word from list, match it copy values next to it
SolvedI 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...
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...
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
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...
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...
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...
Macro-copy data from one workbook to another
ClosedAll, 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...
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'!...
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...
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...
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...
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...
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...
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...
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...
Wireless router password
Hello, I need a password for my router192.168.1-1 at 22356 mcintosh avenue, maple ridge bc. canada papa
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...
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...
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 ...
Concatonating within commands???
SolvedOk - 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...
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...
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...
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...
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...
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...
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...