Best answers
Best answer: To create form go to visual basic editor (ALT + F11) >>Insert>> Userform find how to fill controls (text boxes, labels, buttons) into a userform by searching in google When userform is created and make a macro to show that userform on clickin
Best answer: try =if(isblank(cell to be copied)," ",(cell to be copied))
Best answer: hi! i want to read data from one excel sheet through my MFC VC++ applictaion and i want to write those data into another excel worksheet.if u know the solution can u please send me the solution.
Hi, I hope someone can help! I have a .csv file open with excel that contains a large amount of data that has been merged together so that each data set follows each other vertically. All the columns are aligned and the column headers are repeated in...
Best answer: Hi, You can create a personalized macro function : Function CopyComment(cel As Range) CopyComment = cel.Comment.text End Function And after if you want to copy the comment of the cell sheet1 A1 in to cell sheet2 B2, you can do it by using thi
Best answer: One thing I noticed is you may have to have ActiveSheet proceed each method. As an example, here's a short macro that saves the data from each cell in row H into a word document. The macro is saved in an empty Excel file and it works for any
Best answer: The following also solves the problem: Instead of selecting the Row that you want to apply the autofilter on, Select all the columns (A, B, C ...) and then apply the autofilter The above solution does work however, but I Think this is much ea
Best answer: Thanks for yoru kind words for me. Try this formula and do let me know =IF(ISERROR(INDEX('RAW DATA'!H:H,(MATCH(SheetA!D10,'RAW DATA'!A:A,0)))) ,"Not Found",ISERROR(INDEX('RAW DATA'!H:H,(MATCH(SheetA!D10,'RAW DATA'!A:A,0)))))
Excel - Copy a "Comment Text" in to "Cell T
Issue
Solution
Note
Issue
I can't find the formula how do Copy a "Comment Text" in to "Cell Text" in another sheet.
Solution
You can create a personalized macro function :
Function...
Best answer: In sheet1 cell A2 if sheet2 cell A4 has the data: ='sheet2'!A4
Hello, I have designed a self-grading test. What I would like to do is have data (Name, Date & Score) saved on the next available row in a new sheet. So that when I clear the info from the test page & someone new takes the test, the old & the new data...
Best answer: Sub CopyRowsWithNumbersInG() Dim X As Long Dim LastRow As Long Dim Source As Worksheet Dim Destination As Worksheet Dim RowsWithNumbers As Range Set Source = Worksheets("name") Set Destination = Worksheets("name") With Source LastRow =...
Best answer: Dear Mimic, Please consider using the below sample to have the problem solved: If Sheets("Sheet1"). Range("I5").Value = "Sample" Then _ Range("I5").EntireRow.Copy Destination:=Sheets("Complete").Range("A1") Thanks in advance.
How to remove Hyperlink on copied text from website?
When copying information on website, obviously the hyperlink from the text will also appear on the edited text.
To remove the hyperlink from the text, you need to right on the...
Excel - Copy down formula if cells on left non blank
Issue
Solution
Note
Issue
I need code to copy down a formula from R2 to R3, R4 , R5 etc only if H3, H4, H5 etc is nonblank.
I also need to copy formulae from U2:CY2 to U3:CY3,...
