location

I have a table in my workbook with 3 columns - path, filename, and paste location. The code loops through my table opens up the file and path I have listed, copies some data, and then I am trying to paste that data into my workbook in the range name I have listed as paste location. After copying...

Hi everyone, Thank you, in advance, for any help! I jumbled together this code which does what I want, however, it is very slow. Could you please help me to identify how I can make this more efficient and effective? I have multiple spreadsheets with similar and different data, that needs to...

Iam trying to Vlook from one work book to another work. Cursor is locating correctly but not picking up the lookup value. Dim LValue as String lookFor = Internal_Sheet.range("A2").value Set IFRange = Snow_Sheet.Range("A1:I200") LValue = Application.worksheetfunctions.Vlookup(lookFor...

Good morning :) I've been looking all over for a macro that does what I need, but I have been unable to find one, so I will appreciate ANY help someone can offer. I have a report that has about 150 rows and 9 columns. One of the columns is "Start Time". Every time there is a change in "Start...

Hi everyone, I am a novice Excel user and I'm trying to create a dynamic sheet for my company to use. The gist is like this: I have 4 pieces of information. An event date, event name, location, and link to notes. I have these listed out in rows. What I want to do is be able to automatically...

Thank you to anyone who can help me. I need to insert 4 blank rows every time there is a value change in column B. AND, if you're feeling happy, I'd actually like to insert 5 rows...4 blank ones and the 5th being a copy of the header row. The copy of the header row needs to be exact..same font...

Hi guys Would like some help with this one please I have a spread sheet/ workbook assisting me with my fleet of vehicles and their varying locations daily that my staff (working different duties) require However, some days my fleet requirements are greater in some locations than others...

I have a list of values. These particular values are numbered 1 to 90 (in A2:A91). The values in column B (B2:B91) are 1 to 45 with each occurring twice. I want to setup formulas on a different location on the sheet so that I can have a list of the where each occurrence of the values occurs...

<colgroup><col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="77"...

Morning, I'm hoping the title of my post explains my questions. If not, maybe my attachment will. In short, on older versions of Excel the location of the file used to be displayed under the file name. Knowing that helps me to decide if I want to click "Save" or "Save As". Small issue, but...

Thank you all for the great help this site has already been to me. I apologize upfront if I provide too much detail, but I do want you to be clear with my request. Column E Column F Summary: What I need to accomplish is to extract the string data from column F to see if it...

I have a spreadsheet that has many Tabs. I have named each of the tabs with a unique name. I would now like to insert that tab Name into each worksheet in location A1 without having to retype the name each time. TIA

Need experts help on this after racking brain over and over. I have a data sheet, 'DATA', that contains Product and Pricing detail by row. Each row will have a column for Product Name (ie. Product A, Product B, Product C....etc), and a column for Location, (ie.Location 1, Location 2, Location...

Hi, I'm trying to consolidate data from multiple access databases into SQL Server. The code works fine but the only drawback is when there is a new column in a source access database table 'Db Location' it results into an error. Is there a way in SQL where I can specify to SKIP unmatched fields?

I am looking to count what locations are using a specific item. I am not sure the best way to do this based on how my data is generated from an external source. I don't like adding sheets/columns if needed. Any suggestions? CURRENT SET UP SHEET 1 COL A= Locations (70,000 rows, but only 10...

i'm fairly new to Excel VB, it would be great if you can provide your input on following questions: 1. if we make customize ribbon it loads from excel startup folder, is it possible to load it from a different location? 2. if i have a addin, how can i transform it to customize ribbon and load...

I currently use the following code to print all worksheets named with a 5-digit name (eg: 34716) For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then ws.Range("P22:U22").Font.Color = vbWhite ws.Range("P22:U22").Interior.Color = vbWhite...

A program I use outputs data in a non-pivot friendly format. It has already grouped the data with different levels. I am trying to convert this data into data that is pivot table friendly. I currently have data like this where Location is always filled out and will have at least one (but...

All tabs on same .xls file. Tab CurrentCases has named table with active cases, client name, contact info, follow up date, ect. Tab Outbound is working space, cell K3 references another cell so it contains the next business day. I have a drop down box on Outbound with data validation to...

hi all, I'm after some help please, I'd like a macro that when pressed via a cmd button will save my workbook using the text in cell J1 and N1 and then add the current date which is in cell L1,and if possible to be saved in the current location! Thanks!