excel & vba 2007

<colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody> date doc no ledger narr amt balcne 01-04-16 A001 ABC XYZ 1000 1000 01-04-16 A002 BCD RTY 2000 3000 01-04-16 A003 CDE...

Hi All, Here I go again requesting for help. :(:( So I have multiple workbook, which will be the dump file of the userform I made. basically what it do is track activity of each employee. This workbook called TALTracker has in itself the userform. when you open the file, the userform pops out...

Hi all, My research on this topic has only really turned up vlookup which I don't believe that is what I'm after but could be wrong if someone broke it down as to why it would work best. Any way, I have my first workbook called 'barcodes' and the column of interest is K. My second workbook is...

Hello!! I have this code to insert some information in shapes. Selection.ShapeRange.TextFrame2.TextRange.Characters.text = "ID: " & GetWiId & vbNewLine & "Title: " & title & vbNewLine & "Completed work :" & GetWiCompleted & vbNewLine & "Remaining work :" & GetWiRemaining I want it to appear...

I have a workbook which creates Word reports based on a Word template and tables in the workbook. Depending on the equipment type, it copies a range from the spreadsheet and pastes it to two bookmark locations in the word document (bmInternal and bmExternal). I tried using PasteAppendTable...

Hi, I've built a report in MS Excel which contains multiple tabs and extracts information from a MS Access database. As part of this I'm trying to select a specific table and count the number of rows where a certain criteria is met before then moving on to do the same on another table. In my...

Hello I need to order data column on a unsequential order Actual aaaaabbbbbccccc Desired aabbccabcaabbcc Any suggestions are much appreciated

I can freeze either Rows OR Columns, but I would like to freeze both Rows 1,2,3 AND Columns A & B. Can that be done?

<colgroup><col><col span="4"></colgroup><tbody> Quarter_1 Quarter_2 Quarter_3 Quarter_4 Vendor_1 493 493 399 232 Vendor_2 388 408 390 281 Vendor_3 270 371 285 221 Vendor_4 386 287 371 152 Vendor_5 126 274 136 416 Vendor_6 454 238 465 313 Vendor_7 381 392 396 166 Vendor_8 345 232...

Friends i have a .txt file which contains many columns of data and i want to import only the selected part of data from that .txt file. Is it possible to do that. Normally i first go in data tab in excel then i click on from text button to import the data of .txt file, but this imports all data...

I created a new worksheet's and its 'worksheet_change' event procedure in 'worksheet_change' procedure of a existing worksheet, in its code I also pasted value in the new worksheet created newly, when I ran my code, the new worksheet and its event produce could be created properly, but the...

Excel 2007 My excel macro suddenly stopped working on a Windows 8.1 professional. The macro starts and then just continues to run until I stop it. Even if I "run to cursor" in visual basic the macro seems to be doing nothing and will run until I stop it. This macro has been working for...

Hi, Here is a code: Private Sub CommandButton1_Click() Dim varNames1 As Variant Dim varNames2 As Variant Dim lngArr As Long Dim wb As Workbook varNames1 = Array("FIRST\GRAND EVALUATIONS.xlsm") For lngArr = LBound(varNames1) To UBound(varNames1) Set wb = Workbooks.Open(ThisWorkbook.Path...

Hi, I've following UDF which joins cells value together with given parameter. Since I want this UDF to be available in all workbook, I want to save it as Add-in(.Xla). How can I make it work via add in? Currently it works as shown in below Table. Public Function MultiCat( _ ByRef...

I have spent the last two weeks reading many forum posts trying to solve my problem. I have been unable to find a clear working resolution. What I have:A power point presentation that has information in the slides that pull from excel files on the network drive.(Paste special, link to excel...

Hello Everyone, I'm new to vba and need a little help getting certain cells formatted based on their date in number value. I basically have a large calendar displayed in row format as shown below. The numbers displayed are actually number values associated with the date (ie Oct 1 is actually...

Am new to this community, how do I find the average value for a particular range of cells, the range for which is determined by the value contained in another cell? Ie: I have Students Marks Data as Student id No., Student Name,Section,campus Name(college name),State,SUB(MAT,PHY,CHE)MARKS IN...

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected - Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular file directory. I don't want these worksheet names to change nor the workbook name to change. The...

I have looking for a vba to achieve the following, without success: Count for the number of unique in style Column. Place that count in sku_to_style_count column When there are more than one sku related to a style column, add a blank row after nth unique style Copy that style to the style...

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example below I have a client called "Joes 27" and on that sheet there is sales data listed daily. I am...