The discussions
Vba to assign a counter to a constant
Can somebody provide me the VBA code for the following samples Before VBA code A B B A C A C A After VBA code 1A 1B 2B 2A 1C 3A 2C 4...
How to convert dd/mm/yyyy to mm/dd/yyyy
Hi All, Kindly help to convert DD/MM/YYYY to MM/DD/YYYY for the following examples. Thanks in advance, 19/08/2014 13/08/2014 13/08/2014 4/08...
Copy and paste macro
hello, I am new to the vba programming for excel 2010 but what I have been able to ascertain has helped me tremendously at work, however I am having ...
Converting numbers to alpha
I need a simple way to convert a price to an alpha code, for instance Graystoke = 1,2,3,4,5,6,7,8,9,0 so if a price is $5.66 it appears as s.tt I n...
Percentage work
SolvedHi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...
I need a macro please
Hello, I have 70,000 lines of data. I need to make 1400 files of 50 lines each from the original 70,000. So I'm hoping there is a macro that can p...
Recurring weekly date
Hi, I'm wanting to set up a weekly review date for a number of rows on a spreadsheet. Each row has a different start date. I've tried WORKDAY.INTL wit...
Text label and value if value in other worksheet is > 0
SolvedHello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...
How do i get my old inbox back?
SolvedMy computer had some network difficulty. After shutting down I noticed my Outlook Express inbox was empty. When browsing to my OE folder I see two i...
Question with if function
Hello, I was wondering, if I have for example in C2, C3, C4 the next info: "Tableta Onda V989 Allwinner A80 Octa Core 9.7 Inch Sistem Operare A...
My ipod won't let me use apps
ClosedHello, I got a brand new iPod touch 2nd generation as a gift for Christmas. I synced it with my mac and every song/video/app downloaded with no probl...
Short cut to caps while typing.
Hi, I would kindly like to inquire whether it is possible to highlight a given group of words or sentences that are in small letters and turn them in...
Take reference from previous sheet automatically
Hello, I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i...
Allow my outgoing mail
Hello, I have tried 465 and 587 and 25 all do not allow my outgoing mail can some help me with my problem
Excel - to generate unique id
SolvedHello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...
Decrease the value first by 10% and then increase the value by 5
I want to decrease the value first by 10% and then increase the value by 5%. What is the formula in Ms excel.
Security code
Hello, Please consider using the below codes in order to have the phone restored to factory settings and hence get the present difficulty expe...
I need a macro please
SolvedHello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...
Excel using date range and formula on separate sheets
I'm creating a bank register with the dates in column A. Values are in columns C and D. The title of my first page is 'Register' What I'm trying ...
Copy daily cost entries into the particular ledgers
SolvedHello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...
Need msexcel 2007 formula
Hello, Masters of Excel. I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief. T...
Excel cell equal another cell only if its a certain percentage
Hello, I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its ...
Date entry
SolvedHello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he shou...
How to lock or password protected specific cell in excel 2010
SolvedDear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. Pleas...
Checking cell value against a range of numbers
Hello, I want to check a cell's value and if it falls in a particular range then I want to write "OK" in some other cell and if it falls out of sp...
Help with macro in excel
Hi I need some help in writing a macro for the below: 1. In sheet 1, I have column A with a list of items and many of them will be repetitive, ...
Date change in excel sheet
Hello, in excel sheet date come to 29/12/2014 now i wants date on 29/12/14. so help me how to change date format or use formula to change date fr...
Compare excel data
Hello, In excel i have say the following coordinate data: 2792691.388 215476.765 423.165 2792691.388 215526.765 423.045 2792691.388 215576.765 ...
Excel macro to format report
SolvedHi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of submit..........
Excel file is corrupt.
I hope one of the experts here will be able to save the files, which are very necessary for my work. My excel file became corrupt for very obvious rea...
How to format a cell based on date in another cell.
Hello, i.e. We want to format B1 based on date in A1. ( If date in B1 is 2 or more days higher from the date in A1, then B1 must get colored. This...
Dropdowns in excel
There are multiple ways in which you can create a dropdown list in Excel. Data Validation Form Control (Combo Box) ActiveX Control (Combo Box) But...
Conditional formatting based on dates
Massive long shot here.....I'm trying to conditionally format certain cells to black out after the end of a certain month. It is for a monthly time...
Move completed data in sheet 2
Hello, I have raw data in sheet 1. I need to move completed data in sheet 2. I m using column H to update work status as "completed or pending". Pls...
Excel vba - color code column cells based on values
Hi, Super new to VBA, and need to write code to evaluate the values in Column I, starting with I3 and going down a varying number of rows depending...
How do i change the format "yy/mm/dd" to show as "mm/dd/yy"?
Hello, I have a spreadsheet that I need to convert the date fields from the format "YY/MM/DD" to read as "MM/DD/YY". For example, if the field c...
Need to write a macro to copy a row of information if true
SolvedHi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...
Typing master question
is in this application full study can be done.....?
Vba cut/paste in another tab
Dear all, I'm trying to copy in a different tab all rows that indicate in column [AN] a value less to or equal to 12. However, this column, as i...
Transfer data from a sheet to another many sheets
Hello, I am trying to transfer data from one sheet to many other sheets . For example , when I write data to a row , I woul...
Outlook pst fix
ClosedHello, I have MS Outlook 2007. I recently had a problem with my computer, where when Outlook starts up, a message pops up saying "Cyclic Redundanc...
Assistance with excel macros
Greetings all My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to...
Conditional formatting a row from a validation list
Hello, OK, I am trying to apply a conditional format to a worksheet whereas I have a validation list in a column at the end of the row of data. Ba...
Excel-macro to sumup data from multiple workbooks to master xlsx
Hi All, Can you please help me. Scenario: 1. There is a common template which has some tasks listed in columns against which the team members wil...
Vba help!
Hello, I am absolutely a novice when it comes to macros and VBA and need some help. I have a workbook with 6 worksheets. The first work sheet ("Al...
Using a macro to copy & paste from one sheet to another.
SolvedHello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies everything ...
Excel formula numbers to dates
SolvedHi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143 is 9/...
How to use releative refrences in conditional formating??
Solvedthe first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as you c...
Transferring data from a excel workbook to another automatically
Hi There, I'm fairly new at macros and I would like to write a code that will help me transfer data from a workbook to another. I update Workbook 1...
Conditional formatting based on another cell
SolvedHello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...
