Toma Ovidiu says: Show Hello can VBA code be inserted into Excel 365? if so how?
Anat says: Hi, I'm trying to add a blank row between every row. When debugging, it looks like there's an issue with the following string: Please help me resolve this <3 Kel says: Hello,
TARUN says: Hello everyone, I would like to ask you for help with my problem. I think it's possible to solve it with VBA, but I'm not sure how to do it. there is two sheet named INVOICE and INVOICE LIST. I want transfer invoice Item Data Row wise as per Invoice No, Date and Consumer Name to INVOICE LIST Sheet as per Column Basis by clicking SAVE BUTTON Automatically. I want to create NEW INVOICE Button for Generate Invoice No Automatically. INVOICE Invoice #: 2 CUSTOMER: ß Save Button ß Edit Button ß Cancell Button ß New Invoice Button Sub Total ₹ - 5% Tax @ ₹ - Invoice Total ₹ - INVOICE NO DATE CONSUMER NAME ITEM1 ITEM2 ITEM3 ITEM4 ITEM5 ITEM6 ITEM7 ITEM7 ITEM8 ITEM9 ITEM10 VALUE Yen says: Hi, I'm looking for a solution that create a button to print excel worksheet with print range A2:AA73 from a workbook into pdf and save a copy of pdf in specific file location and file name will be based on each sheet cell value at AD2 Can you help me with how to code that part? I'll be really appreciated your help. Nazar says: Hi everyone, Now I want to copy cell D23 value and Paste value only inside the Cell Range : B30:B54 where Cell C23=matches with Cell A30:A54). Kindly help to write code on VBA in excel. Prasanna says: Thank you very much Dawka says: thanks Irene says: Hi, I'm looking for a solution that is I created a report on excel and I also created a button to export that report excel file into a pdf and its location is on Sharepoint, not in some folder only on Computer. Can you help me with how to code that part? I'll be really appreciated your help. GuyGuy5555 says: Is there a code set or technique to get an excel sheet to read all the documents in a folder, their headers (if they are word documents) and then build a hyperlink list with colums that display data fields from the header like dates/vital-info/etc. Is this possible? M Shaw says: Hi Lawrence says: I've written a whole script which works in extracting all the information from a Questionnaire in word to excel. However, the only problem I've run into is when questions within the Questionnaire has tick box options. My current VB macro script just pulls in the box symbol, but not the words associated with the ticked box/next to the tick boxes. Is there a VB macro script you can recommend I can write which allows me to pick up the text associated with the ticked box instead? Zeeshan Hyder says: Hello, Daljeet says: I have 2 Dropdown List with the same options (Included and Excluded) in different sheets. If I select " Included" in one dropdown list, it should also select "Included" on another dropdown list and vice versa. I need VBA code to crack this. Priyantha says: I have an excel excel workbook .It has four sheets A, B, C, D .A, sheet information .Rowes' information is categorized in C column. VBA code so that the information contained in the Rowes can be found on the B sheet, the information on the C on the C sheet and the information on the D on the D sheet. want to . Priyantha says: Hi bridget says: this deleted active names as well so my entire excel has #name error now. is there a VBA that only deleted names that are not used Pats says: I am having an excel wherein i have done some conditional formatting with color coding and i just want to copy the color codes to another fields, can you suggest a macro VBA so that i can run it? Gerald says: Hi May I request the expertise of those who are professionals in VBA. I'm planning to improve my procurement monitoring in excel using the VBA wherein I want to simplify the way I can search for the status of purchases. By simply typing the reference number in the search bar then the status would appear. Would that be possible in excel VBA. Thank you in advance for your help Alex says: how i can give command in execel Alice says: Hi, I need a code to color the sheet tab to red if T43 in that sheet is > 0, no change to sheet color for all other cases. I'd like this to run for the entire workbook of 160 sheets automatically. Can someone help? Thank you. Alice
hussein says: please can I have a cod to calculate the average for each 29 number of excel column with 184450 row Los says: Hello everyone, I would like to ask you for help with my problem. I think it's possible to solve it with VBA, but I'm not sure how to do it. Also, if there is a way to do it without VBA, even better. Jagan says: I Want use VBA code flash data on return on blog Arihant says: Hello, thank you for your help. If possible, could you please help me with an additional problem? I have around 1000+ xml files and I want to convert them to excel or csv file. Is it possible to do that as well? If so, can you show me how? Thank you for your time. Ash says: Hey! I am looking for a little help with a code. I am a beginner it is a little confusing.. Change the application so that now there is no limit. For EG, if the strategy says to buy 30% more shares but there is not enough cash on hand to do so, the investor will now borrow the cash they need. Now the cash positions in Capture the maximum the
investor ever owes during the year in an extra output cell, keep Rajkumar M says: Hi Sir i want to count diffent names in coloum wise what is the formula or code? Bala says: i am new vb in excel and need some assistance with the following macro. any help greatly appreciated. i need to create a macro which will take value from sheet 1 cell A1 value ,(example: CD-600500 is available in sheet 1 cell A1) then increment the value by 1 in sheet 2 cell range A5:A50,also A5:A50 if the cell is blank try goto next row and increment the value by 1. vidhu says: I need a code to convert half of my numbers to variables. example if the number is 12345, i need to convert it as ABC45. (A=1, B=2 Etc..) Someone Please help. Nicolai says: hi there, im quite new at programming but uses excel alot so what im looking for would help me quite alot. sorry if the explenation is bad, English is my second language. Sukhbinder Singh Bhogal says: Hi Friends, one of my friend did find an issue where one row data was into single cell with a separator "|" pipe sign of each rows where he was finding difficult to use filters as the file was large about 2500 rows and thus it was cumbersome to copy paste it. Thus, he asked me to help where I could do it with VBA coding. Short Program - Option Explicit Sub CellTruncateData() Dim CellData, TempData As String, Counter As Integer Counter = 0 For i = 48 To 2541 CellData = CStr(Application.Workbooks("Test.xlsm").Worksheets("O_test").Cells(i, 1)) Next Application.ScreenUpdating = True Mayank says: Hi sir thanks for sharing the info., my question is after saving the macro and its respective workbook if I want to run the same macro in other workbook will it work because i have tried it in the other workbook but it has not worked in other workbook or if I open the new excel sheet. bibek says: hi... i need a vba code for making my worksheet for attendance system where after entering the time of went and out the people cannot edit except the user coder by keeping their password system or any method..
Ezio Abbate says: Hi everyone I have a small problem with a vba to create with excel. I expose the problem: I would like to enter a formula that: The moment I enter a particular name in one cell, other names that I decide, appear in other cells. It's possible to do it?
Clamhead says: The code I copied from sount and sum cells by colour does not show up in the Macros name list after I have done the steps. Ubaid ullah says: I want a coding that use in ms excell for spellnumber formula Those convert a no in to write text Pradip says: Sir/Madam, I am an excel user. I am facing a problem. Here is a vendor who gives services various pathological test;like TC,DC,ESR. T3,T4,TSH.LFT etc.I want to create a database file in Sheet1 and where these tests are kept. Now day by day there so many patients examine their various patho.tests. I want to create that type of database when I write the test name the machine invoke the respective test and rate and put the value againt that particular patient. How can I solve the problem? Awaiting for your positive reply. Hemanth says: Can anyone please help me....... My requirement is i have an a master sheet having 5000 rows and 5 to 6 columns.... In that sheet i will give you one column data in another sheet automatically remaining column wil fill...is it possible Ankit Singh says: Hi, this code show text format show date but i want date format please help me. DoGGoD says: Hi! Mzamo says: Hi How can I write a code to do the following; If content in( W3:W395) is blank then delete the content in cell (G3:G395). Please help. Bruce Onisko says: Works perfectly! Thanks! Kev says: I was wondering how I can modify the code to have all the excel files into 1 sheet instead of each individual sheets? Thank you Haku says: Hello, i would like to change the address from where i am sending all the emails using the VBA macro excel. How do i change that? i dont know i am clear o not. Every time i send the emails from the VBA macro i would like to that "sender" appears a different email address than from where i am really am sending from. John Sekene says: I am new so hope you can help. Yasir says: I want to develop a VBA code; let us suppose we have values like 1 2 3 4 5 in col A1 A2 A3 A4 A5 and other values like 6 7 8 9 10 in col B1 B2 B3 B4 B4 B5 and I want to write 1/6 2/7 3/8 4/9 5/10 in columns C1 C2 C3 C4 C5. Keith says: Is it possible to call excell or word, without needing to specify which version (ie word 14, word 15 etc). pritam gaiwad says: in vba modules are saved by which extension Nathan says: Hi Thank Rawad says: Hi example: let say the word (Rawad) and we have R = 10 , A = 1 , W = 700 and D = 3 so the total of word Rawad must be 10 + 1 + 700 + 1 + 3 = 715 thanks in advance Khansab says: Sir please forward Ur good comments that how I easily access what kind of book in Pakistan for learning VBA codes. Khansab says: How I made search button in excel VBA helio says: Hi - I am trying to create a Button in my sheet for a randomizer formula I set up. Basically, I have a list A:A of SKU names and B:B Random(1,5000) sunil says: dear sir\madam Ivin Chibanda says: I am failing to locate and make the Vb code John shervell says: Hi I cannot figure out how to have a row of possible 100 numbers that when I enter a number in cell A1 all the numbers move up one cell and the new number appears in B1 any help would be appreciated vijaykumar says: Hi, Judith Hodges says: I performed the task but my spreadsheets did not merge what did I do wrong? All of the examples I followed but after the Alt F8 I was lost because it did not show what to do next or what I should be looking for. Saurabh Kulkarni says: Is import function runs in excel 2010? previously i created a code using import function to import .bas file into many excels sheets by running this code. now this in not working for excel 2010. can anybody please help me out here?
ExHell says: I only need to remove carrigae returns in 1 column in my case Column H. How can I define the range to be H, and not the whole sheet? Thanks Abrar Ahmed says: can you please tell how to copy paste from row1(sheet1) to any cell in sheet2.. and create a button for going to next row in sheet1 S.M.P. Karunarathna says: VBA Macro for Change Case works well ROHIT KUMAR PARASHAR says: Dear hoe to i set vba project in colum as(rohit kumar parasshar)in single colum i read in a video (by right click view code entir.excel.com (Private Sub Worksheet_SelectionChange(ByVal Target As Range) Jose Eduardo says: There are many mistakes in this post Carlos Twain says: Im afraid horrible text and doesnt work Carlos Twain says: This does not work Margarita says: I want to thank you for this code and tutorial. I don't write VB code and just need a quick solution to a problem and this resolved it. Thank you so much for your time and effort. Karen says: Hi I am trying to create a template workbook for some data analysis. I have worked it up but now need to delete the data and save it as a template. I was just wondering if you have a workbook that has a VBA code attached if it is save as a macro enabled workbook do you have to add the code again when you reopen the workbook? Many thanks, Karen
robert rowland says: Dear Sir / Madam. Tafadzwa Munganasa says: Thank you. Works perfectly!! Delmar says: Hi there,
Lindsay says: I just want to say thank you for this fantastic, simple solution and for your awesome products in general. PAVAN says: Hello, I want a code which is used to cut the rows having the red color and paste in another sheet and when color changes to white should transfer to same sheet (online spread sheets) MADHUSUDHANRAO says: IT IS VERY NICE THANK YOU imtiaz ahmad says: Hellow Team, we need your help for VBA Coding in excel i don't know VBA coding how to start
cindy says: Hello, Anyone who can assist me to provide a vba code on how to generate a responses that will be consolidated to another worsheet. Example, Response with "Will be included in the remediation" and "Partial Remediation" will be generated to the consolidated worksheet. Thanks Javier says: Hi All, I would appreciate if someone could help me with some VBA coding I need to do. I am creating a userform for an excel document. It is quite simple but I really dont know how VBA coding works. I have 6 categories in my spreadsheet that have got to filled up in the form with numbers from 1/10 and then there is a comments box to for extra comments and a name box for the user name. finally it has 2 command boxes: Add company and close form. It would be greatly appreciated PeterF says: Thank You! Big help! Yana Nina says: Hi! Sophie says: Thank you so much. Big help. Nurul Islam Chowdhury says: Excellent guideline. Thanks. Sohaib says: Hi this is Sohaib. I have learned the VBA for converting numbers into words but I also want to add the word "only" after converting the numbers into words. Please help if you can.
Fernanda says: Hi, I added a VBA code for a new Formula (CONCATENATEIFS) and it works greate but the only problem is that its super slow, I tried to use your speed up tip but it ended up slower (probably because I dont know where exactly to put it because the formula doesn´t have a Sub line) Can you help me? Thank you very much!!
What does '!' Mean in Excel formula?When entered as the reference of a Named range , it refers to range on the sheet the named range is used on. For example, create a named range MyName refering to =SUM(!B1:!K1) Place a formula on Sheet1 =MyName . This will sum Sheet1! B1:K1.
When inputting a series of numbers you intended to type 110 in a cell but you inadvertently typed 11O how will Excel tell you that you made a data entry error?You intended to enter 110 in a series of 10 values, but you inadvertently typed 11O. How will Excel tell you that you made a data entry error? 11O will be left-aligned, while the other values will be right-aligned.
Why should macros be part of your everyday use with Excel?These macros make Excel work for you. They replace actions that you do manually—everything from formatting cells, copying values, and calculating totals. So with a few clicks you can quickly replace repetitive tasks.
|