advanced excel

HI there. I'm trying to: Copy a range and paste it into another sheet (could I create one on the fly?) Then create a temporary workbook to copy the same information (could I eliminate the step above instead?) Then save the new file as a .txt file on the desktop with a specific name I'd like to...

The following will obviously work so as long as SourceWorkbook.xlsx has a sheet named Sheet1: =[SourceWorkbook.xlsx]Sheet1!$A$1 but what I want is this.. A1 = "SourceWorkbook.xlsx" A2 = "Sheet1" A3 = "$A$1" (as text) A4 = =[A1]A2!A3 This obviously does not work. Is there a way to achieve my...

Apologies if this looks/sounds messy... In the middle of my (probably unnecessarily complex/large) formula, I have this function: (OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-ROW()+2,0)) As it stands, this will pull the value of the cell 2 rows from the top, in the same column as the current...

Below is a quick sample of my code that I have in my workbook. Not all the tabs are the same so for example I want the Macro to do specific things to the "MTD Glance" tab and a couple other tabs, but in the middle of my code, I have a sample of my daily tabs which are numbered "01" thru "31" and...

In my office there is an application that count my active hours and idle hours on my desktop. I want a code that send different key strokes, open files, mouse clicks so that my desktop remain busy all day long. Could someone please help me.

Hello, I am trying to see if there is a way (I'm doubting whether this is even possible anymore) to highlight or mark items that can offset each other exactly given certain criteria (for this purpose Project and Fund Column B and C). For example: There could be 250, 250, 500 that would 0 out...

Hi guys, hoping you can help with this. I currently have two tables, main and input/output below. I need a way to pull the "name" field that corresponds to the "main" code in the main table (which is in column D of input/output table). In other words, a formula to give me column E. Any ideas...

Hi, I'm in need of some help that is beyond my excel skill base at this point. Below you'll see I have two sections, which represent two worksheets. What I need is a formula that will in section 1, under the IDENTIFIER Column pull from all of column A (Transaction detail) all IDENTIFIERS...

Please, I will like to know how to serially append numbers within a cell. For example: I'm trying to create codes to link to assets in a hotel. So, I go like this RM101/BED/001 RM102/BED/002 RM103/BED/003 RM104/BED/004 RM105/BED/ RM106/BED/ Now, I could have dragged it down to number it...

I am trying to determine the best approach to filter the data. The master file has all comparative data, the secondary file will change from month to month to only include portions to match to the Master which then needs to create the filtered third file. Example would include: Master file...

Hello, I'm very new to VBA and excel coding so anything will help here. I'm attempting to track sales data by Product # and Date (by day) in a table in excel. I have the table set up with product # down column B, starting in B2 and Dates starting with 1/1/2016 across the top starting in cell C1...

<tbody> Symbol Price now Paid - Credit/Debit Win/Loss % Expectation % Expectation $ AAPL -1.50 -3.00 WIN 50% $1.50 AAPL +1.88 +1.50 WIN 25% $0.375 AAPL +1.88 +1.50 25% 50% $0.75 AAPL -6.00 -3.00 -100% 50% $1.50 </tbody> I have this Table above I want help for column D and F...

Guys, I am an avid reader of this Excel forum and have learned much things here. I have an advanced question regarding the SumProduct. The problem is: Let´s supose I have a plan to by for my company Cars, Bikes and Buses, with the quantity of that table below: TABLE 1 <tbody> Year 1 Year 2...

Here's the thing: I'm making a list of all threatened species found in Conservation Units of Sao Paulo (Brazil). There are a few categories that species can be included when we talk about their conservation status: - EX (Extinct); - EW (Extinct in the Wild); - CR (Critically Endangered); - EN...

Good day,</SPAN></SPAN> I would like to lock cells that have got formulas inside but that is not possible as those cells are hidden or shown through a Visual Basic code and so when I lock those cells and then apply the Visual Basic code to hide or show the same cells the following message...

I have an excel table with sales data for many presellers. I have to make and updating table for each of presellers. I want to make one file with data for all presellers and to create a shortcuts to preseller folders and when some preseller opens file from his location I want excel to aply...