info

I am having problems with losng my hyperlinks when I save the exel spreadsheet to another workbook name. Is there any way to save my hyperlink info to another workbook so it appears in the new workbook. Any help would be greatly appreciated!!

The formula I am using right now is =IF(M533="",(VLOOKUP(N533,Sheet3!A:D,2,FALSE)),(VLOOKUP(M533,Sheet3!A:D,2,FALSE))) I will either enter info into M533 or N533. If I have no info in M533 and I do put info in N533 I need to have the vlookup pull the info tied to that cell.

Good day Firstly, I am very grateful for the help I received last time round. Whoever helped me thank you. I had a mail glitch so I cannot do it personally. I am trying to help my wife with managing a ******* etc I have managed to construct some stuff but now I am struggling to extract the data...

Evening. My information is on the worksheet called INFO On the INFO worksheet we have the following, Names in column CV Address in column CX Paid in column CZ Mileage in column DB Current range on the INFO worksheet is CV2:DB16 Overtime this range will increase down the page. I have a...

Hi, I have made some tables but having an issue trying to sort them. Some info for you. Worksheet is called INFO Tables have headers in row 1 GRASS NAME CV2:CV16 GRASS ADDRESS CX2:CX16 GRASS PAID CZ2:CZ16 GRASS MILEAGE DB2:DB16 What im looking to do is place a macro on a button which will sort...

I need to get report txt files into excel but can't figure out the best way to do this. Sometimes over 100 pages are in a single report and every page contains the headings and title info as shown below. I've highlighted the main info needed if getting the other data into cells is too...

I have a "Form" that I input a customers contact info in such as Name, company, city/state, phone, email. I would like excel to remember the name I typed in and when I go to type that name in again the contact fields will autofill with that persons information. is there anyway to do this or am I...

Is it possible to have the worksheet name autopopulate into a cell? Example - I want the sheet name to appear in cell F1. Is that possible? Also, if I rename Sheet 1 to 12345, the info in cell F1 would change from Sheet 1 to 12345.

I created a thread yesterday https://www.mrexcel.com/forum/excel-questions/1102769-how-set-range-vba-active-cell.html and this is the continue of my macro which I believe has to change what I had help with yesterday . Sorry for not thinking the whole thing through before posting Here is what I...

Hello, Looking for help creating a Macro to do the following: Sheet 1: Employee Info Sheet 2: Payment Prep In Sheet 1 we input the employee information and assign theman Employee Info Index Number I am looking for a Macro that will copy the data from theEmployee Info tab (which ranges from A2...

Sheet 1 has employee info Sheet 2 are blank employee cards Example is an example of where the info from sheet 1 goes onto sheet 2 If someone could create a macro to go through each case (all rows with data) on sheet 1 and have that copy to corresponding cards on sheet 2 that would be amazing...

Hi All, I hope that you can help. I have 4 tabs on this sheet. 1st tab is my shipping info that I drop into the sheet and 3 of them have info I need to reference from. The problem is I keep getting 0 on half my look ups. So I tried to use =IFNA(IF(VLOOKUP(A2,'Redding...

Hi, My working code is supplied below for you. Can you advise how i can format the info from when its entered into the cell. Could you advise how it would be for the format called GENERAL Private Sub CommandButton1_Click() Dim i As Integer Dim ControlsArr As Variant, ctrl As Variant...

Hi. I have a table containing staff member names (column A), team they belong to, which is numbered between 1 to 30 (column B) and contact info / location info in columns C and D. The whole range is A4:D434. What I'd (ideally) like to do is have a Userform pop up and show all of the staff...

Hello all, It is been long time since i came here asking your help. I hope i can find once again help from you all. I'll put it by steps: Step 1: I need help to create a VBA that will copy a Template sheet to a new workbook (as many times the list has starting on row 2 until the last) the...

I have a cell that has multiple series of info in it, separated by commas. Is it possible for a formula or a way to separate the info in the cell into separate cells using the comma as a start / end point A1 = stop, Tuesday, Blue, four, Loud, Yes Thanks in advance

Hi All, I have a work book with 2 sheets Sheet 1 has a bunch of dates Sheet 2 has other info but also has these dates there but are referenced from sheet 1 If I want to sort by a column with all the info in sheet 2 how do I get the referenced dates to follow the row ? Thanks

All, I have a spreadsheet (containing expense report info) 14 columns wide by infinite rows, at this point I have it set up with a Pivot and slicers I would like to set up a Macro that would automatically "pull the corresponding info" per the selection of Manager's name (which would be...

I have the following data excel code that looks at a sheet of data and sorts the data based on a number and copies it to a new template sheet. A B C............ Line: 51106-02 AB ZONE 51106-02-904-601...

I'm getting a new weird error on a simple "get a sheet from another local file" PQ query. "Typelib export: General Error. See IError info for more information (Exception from HRESULT: 0x80131136) I can't find that Hresult value on any board. Anyone know what's going on here? Client info...