vba macro

So I need your help! Firstly I am a student and don't really know much about VBA, because my teacher skipped those classes, whatever... I have a table with a long number of rows and data in columns.I wanna transpose them to rows and deleting duplicates, so it's better to review the data. I'm...

Hi all, I am hoping someone can help me make my excel spreadsheet read a text file line by line and assign variables to those lines so they can be referenced further down the marco to hyperlink. First I would like the macro to read a .txt file line by line and give say line 1 = certain text...

I was trying to open a excel workbook with VBA macro code Workbooks.Open("Filepath\Filename.xlsm"). It is crashing as soon as it is opened. When I am trying to open manually then it is not crashing. Any idea or suggestions please. Looking for help!

HI, Im a newbie here I just want to ask help because I have hard time finishing my VBA userform. I have a 5 column table I a excele worksheet. I want to have a userform that have 5 textbox according to the headings of the 5 column, im planning that in the 1st textbox if I entry the data the 4...

I need help with my macro. I've got a table of data A1:R35 in sheet "Active" and when the value in column R is 100% and you press this button I want it to copy and paste that whole row into the next available row in sheet "Completed". Here is my current Macro: Private Sub...

Dear All, I think I need to write my very first VBA macro, but I have no idea on how to begin (other than how to open the VBA editor). Maybe I don't need the VBA but I don't know how to do it with the basic Excel functions. PLease note that I am working in excel 2010. So what do I want: I...

I've written a macro that processes seven reports every day. My bosses have asked me to set up a macro that adds to the original macro when new reports become available. In other words, a macro that creates a macro. If nothing else, I figure I can create a blank script in Word, an input box...

Hi Guys, I am looking for simple Macro which would 1) create one meeting invitation 2) would get data to subject/recipients/subject etc. from MULTIPLE cells of same worksheet Could you help me? I really am looking for simple solution :)

Hi All, Please note:- I know about slicer but don't want to use and wants a vba macro only. Below is my query I've 3 pivot tables in same excel worksheet. All 3 pivot tables have 5 report filters and out of them 4 report filters are common. I want to use a drop down list from cell b4, b5, b6...

Hi, I was wondering if anyone knows how to select the "Refresh All Worksheets" for essbase worksheets in a workbook, which if done manually, would be found on the essbase tab's ribbon. I'm aware that there's an add-in for specific essbase functions that would enable me to do this, however the...

Hi Friends, My main data in Sheet1 but i want that data in Sheet2, Sheet3, Sheet4 in VBA For Example - Data in Sheet1 A - 100 B - 200 C - 300 So i want this data like Sheet2 A - 100 Sheet3 B - 200 Sheet4 C - 300 Is it possible, Please help me ?

I'm trying to set the name of a worksheet using the following code, and it's failing to process for some reason. Can anybody help me out with this? Sub CreateNew() intTabs = Worksheets(1).Cells(18, 2).Value For i = 1 To intTabs strWsName = InputBox("Please name Sheet" & i & "."...

Hi I want a formula or a VBA Macro for extracting a series of hyperlinks target files and putting it into user-defined folder. Will you please help me? I know how to extract a hyperlink address and put it into a cell but I can find it enough for this purpose. Regards

I want a Macro that a same text will be copied to different sheets, but the condition is that the text will appear after the end of used rows of the sheet. I want to specify the sheet name in the Macro code & in Column E after the end of rows the Text will be appear.

I'm using the macro below to try to consolidate 4000+ files, but i need to be able to consolidate reports that are divided by the same sheet name in each file (around 8). What do i need to change so i can input the sheet name that i want and then excel consolidate just the reports from this...

Hi, I am trying to create a macro to saveas a file based on the information in cell C80. The macro is throwing an error on the last line saying compile error syntax error. Can you please help. thanks, Sharon Dim Path As String Dim FileName1 As String Path = "C:\PS CANCEL" FileName1 =...

Dim FName As String Dim FPath As String FPath = "C:\PS CREDIT" FName = Sheets("Request Form").Range("C80").Text ActiveWorkbook.SaveAs FileName:=FPath & "" & FName MsgBox "File Saved to PS CREDIT folder" Hi When I try to run this macro I am getting an...

Sub CopyRowDemo() Dim Rw As Long, LstRwRaw As Long, NxtRwDest As Long Application.ScreenUpdating = False LstRwRaw = Sheets("Raw Data").Cells(Rows.Count, "B").End(xlUp).Row For Rw = 3 To LstRwRaw With Sheets(Cells(Rw, "B").Value) If .Range("B6") = "" Then NxtRwDest = 6...

Hi Everyone, I have multiple files with the sheet name "Admin Costs" with varying row numbers in each file. I want to take the value from Cell A2 and paste that value in a different workbook. But the tricky part is that I want to past that value equal to the number of rows I have in Column A...

Hello folks, I have the following issue and will be very grateful if you provide some help: I have one sheet which I need to manipulate some data and copy/paste from it (sample below): I need a script which searches for the word 'Open' in column A and next finds the first non-empty cell in...