The discussions
Excel 2003
Hello, In one worbook (Best Price) I have the following data where Coloumn A, Row 1 is a heading (Range Code) and the data starts from A2. Ro...
Sharing an excel sheet
Hello, I am looking for a way to share an excel sheet with multiple people. each person given a password to see their specific info only. This is ...
Spread sheet / macro/ formulas help!
Hello, I would like to create a spreadsheet that has 4 - 5 specific fields where individuals can type in account numbers, names, a drop down where...
Drowing data from one sheet to another
Hello, Need your kind help with this cause i have no idea how to excute this. What i need is to drow data from one table in sheet 2 to the main ...
Hide columns
SolvedHello, I recorded a macro to hide some columns (says, column M to O). However, when I tried to run the macro again, the macro hide all the columns f...
Importing data from 1 excel sheet to another
Hello, I have a program that exports the daily maximum temperature recorded into an excel spread sheet. Column A Row 1 Date Column B Row 1 Tempera...
Transfer of excel data from a row to another
SolvedHello, I have this excel sheet with numerous rows having columns A,B,C,D &E.column A is numbers & other columns hav data in text.I want to transfer...
Excel
ClosedHello, I was wondering if anybody knew how to take a list of tasks, associate a number with each task, and then be able to put the number in a cell ...
Macro for copying and replacing data
Hello, I'm looking for the best way, which I am assuming is a macro to copy data from one spredsheet to another. The macro must copy all data from...
Macro to copy and paste
SolvedHello, I would greatly appreciate any assistance with creating an Excel macro that will copy information from cells A1, B11:D11, A13, B23:D23, et...
Macro: transpose multiple rows into 1 column
Hello, No previous experience with macros, so any info would be helpful. Suppose I have names in Column A, with 4 scores in B, C, D and E. I wo...
Excel macro help
Hello, I was wondering if it were possible to have a macro that would work for different sheets for having the column be pasted as long as the nam...
How to pull content from 4 cells to 1 cell
SolvedHello, How can I pull content from 4 cells to I Cell in a specific format so that I have it displayed like this: sm=12.00/W123/F456,MD=13.00/W456/...
Excel 2007 macro
Hello, Could you help me in writing a macro for exporting data from certain cells in sheet 1 to sheet 2. I use Windows 7 and excel 2007 Than...
Vba 2010 open files in current folder loop
SolvedHello there, Think this is a relatively simple code and I've found examples but can't quite piece it all together to do what I want to do. I want t...
Excel working time macros
Hello, I am looking for a macro to extract data between certain hours. My csv has start_time and end_time of driver trips. I would like to see ...
Excel macro needs help fast
Hello, I'm currently trying to introduce macros in my reports at work. Everything works fine but there's one thing that I just CAN'T find an answe...
Vba 2010 saving workshts-workbks new file
Hiya, I've found a fabulous bit of code that saves the individual worksheets as individual workbooks. It works brilliantly and I'm just wondering ...
Macro to transfer data
Hello, I am trying to create a worksheet for stock control. When I add the quantity and items needed, as well as the job reference, signed out by...
Vba locate & delete words within a sentence
SolvedHello, I know this is probably very easy but I'm having trouble figuring it out. I'm trying to find a code that will identify key words within a s...
Releasing filter before running a macro
SolvedHello, dear all friends, good morning. I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will be able to store ...
Undo all filters before running a macro
ClosedHello, dear all, I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will store some cell contents of the invoice...
Highlight rows with conditions met
SolvedHello Friends, I desperately need a macro to Highlight /or separate rows when specific conditions met. sample file enclosed. Link http://www.spe...
Excel data comparison and copy data
Hello, Sheet1 details A:employee no (employee no appear more than once) (a2:a5720) B: name C:address1 D:address2 E:address3 F:address4 G:pin ...
Mail merging from excel to excel
ClosedHello and Good morning Everyone. I will appreciate your expertise on this question because I have tried attempting several avenues and still didn't...
Sharepoint link to excel via a cell variable
SolvedHello, Configuration: Windows XP / Internet Explorer 7.0Hello, Wonder if any of you gurus can help with the following, as it has got me totall...
Excel, equating 2 columns formula
Hello, I'm trying to take 3 columns and make them a bit neater. Say column A came from a customer listing such things like Apple, Orange, B...
Reading differrent excel sheets
Hello guys, I have to consolidate the data from different excel sheets (+/- 20/ files) from differrent excel files (20) how can I do it quickly in ...
Macro to capture timing
Dear All, Can anyone please assist me in composing a macro to capture the break timing of my team members. Am desperately in need of this macro to...
Remove "calculate" from excel.
SolvedHello, When opening a saved sheet with data in excel,I get to see "calculate" mentioned on the bottom left. The problem is when this "calculate" i...
Excel/vba 2010 continue with macro
SolvedHello, Just a quick question I've got a Macro that runs perfectly except there are two times while it runs where it stops and asks you to click Ok...
Excel to excel mailmerge, is it possible?
ClosedI have a list of names, with their room numbers, acct. numbers, birthdays, and addresses in excel (roster.xls). Every week, I had to print several ...
Vba code did't open workbook
Hello, I'm having a major headache in figuring out why the VBA code which I'm applying at my office computer seems to work perfectly but fail to w...
Vba conditional formatting excel 03
SolvedHello, How can i apply a conditional format on a certain cell but with the condition in a different cell. F.e. if a cell in range C1:D5 (f.e. C...
Transfer from one excel sheet to another..
Hello, I have an excel sheet (Sht1) with data in one format - A2,B2,C3,D2 A3 A4 A5,B5,c5,d5 A6 A7 A8,B8,C8,D8 A9 A10 I need to trans...
Excel 2007 - deleting the last three rows
Hello, I am looking for a formula to put into a macro that will scan to the last three rows with data/ information and delete them. Thanks,
Macro/ vba forumla help-deleteing entire rows
Hello everyone, In Excel 2007... I'm looking for a function/ macro/ VBA formula that can assist me in scanning one set column (but the numbers v...
Excel 2007 - macros
SolvedHello, I need to write a macro for following example. Item Qty c 2 B 2 b 6 C 5 c 5 a 2 Basically I want to group by Column A (i....
Excel macro formula to sum column
ClosedHello, I need help with a macro please. I need a code to sum up Column E from line 3 to the end of the data. The formula needs to be in the cell r...
Excel 2007
Hello, I have a table that lists historical rates of returns for years between 1901 to 2010. I'd like to create a table that 1) will list each year...
Add two cells if one cell is not blank
Hello, I want to add E9 and D10 if D10 is not blank (or is greater than zero), whichever is best. Can anyone help please? Configuration: Wi...
Repeating rows n times & copying
Hello, I have an excel sheet which has a lot of different columns.. what I want is to copy all the rows n number of times and paste it in another...
Highlighting and copying in excel
SolvedHello, I am just starting on visual basic and would like to record a macro whereas, once I have pressed play, Excel will select a cell 12 rows dow...
Please help me to revise the macros
Hi, The below macro is composed to capture the start time and end time of a employee. When i run the macro, the start time and end time is captured...
Printing excel sheet with jumbled columns
SolvedHello, Dear all, I have a typical question. I have a work sheet in excel 2007 with some headers in columns from C8 to N8 the columns C to F have t...
Excel/vba 2010 - searching for wild cards
Hello, I'm wondering if it is possible to write a code that will search for wild cards. For example: we have a pattern of numbers that come up in ...
Variable sharepoint link into excel
ClosedHello, Configuration: Windows XP / Internet Explorer 7.0 Looking to allow a cell value to dictate a link to a spreadsheet in Sharepoint. S...
Vba macro matrix multiplication with a scalar
ClosedHello, I've been struggling with what should be a simple operation using Excel VBA and was hoping someone could please help me out. Basically I hav...
Please help with user form in excel.
Hello, Hello, I'm getting stumped and just need someone to help out. I know I am over looking something simple but can't figure it out. My user ...
Excel office2007 macro
SolvedHello, I writting a macro to clean up the format of a report down loaded into excel. I'm stuff on on section. I have filter column A for blank cell...