The discussions
Vba or change settings for "picture format "
Dears, If any one can help me either by changing some settings or through VBA code. The case: I have excel workbook including 100 worksheets fo...
Excel: exporting rows that meet criteria
Hello, I'm new to this forum and also to macros so please excuse any technical slip-ups. Thanks in advance for help! I currently have two Excel wo...
Searching text in excel using macro
Hello i want to search words in excel using macros. i have two sheets(sheet1 and sheet2). i have a column,say E, which has 50 text rows. i need ...
Access 2010 - table with same fileds and rows
Hello evryone, need your kind help with the below, i'm using Access 2010 and i created a main form , from which i want to let users to open new ...
Compare 2 excel sheet and combine uniq data
ClosedHello, I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All I want is to combine both with no redundant ...
Need help figuring out a formula or macro
Hello, I need some kind of formula or macro that can do the following: If the exact value of a cell in column C is found anywhere in column A, ...
Submit button macro
Hello, I need a macro that will be assigned to a "Submit" button that will move data from Column H on my "Data_Entry" sheet to a different column ...
In excel formula i need to use dynamic range
ClosedHello, I need to use dynamic range for excel formula for example If condition is unmatched from next step I need to terminate the counting & start ...
Excel help required!
Hello, Hoping you guys and gals can help. I am currently uploading many items on to a website. I have a spreadsheet with all the different supp...
Macro to import data excel to excel
Hello, Let me preface with the fact that I am using Excel 2003, pretty fluent with Excel in general, but new to the macros and visual basic - alth...
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...
