This is not looking for a solution its more so advice on if its possible.
Was looking to create a dynamic floor plan in Excel where on the raw tab you would enter certain dimensions of a piece of equipment and it would then map it on a sheet. Something like Item A being 6*3 meaning its 6...
I am trying to make a table that turns this:
Wondering if you could help me here.
I am trying to create some profiles for some players in which I change the name and their picture changes.
I have created a table with their picture next to their name and followed some instructions online to make dynamic pictures however I keep...
I have two sheets. Sheet1 has a table of data that I will need to lookup, and I will be pasting data from another workbook into Sheet2 that has somewhat consistent column headers but in different orders. I want to put a formula in Sheet2!A:A that finds a specific column in the pasted data and...
Dim rngCell As Range
For Each rngCell In Sheets("Final").Range("F13:F" & rowLast)
If WorksheetFunction.CountIf(Sheets("Filter").Range("A1:A" & rowLast), rngCell) <> 0 And _
Range("I" & rngCell.Row).Value <= 0 And _
Range("D" & rngCell.Row).Value < 50 Or _...
I am working on a report which divides total income down to each consultant.
In a sum up page I sum up the total amount of income on different projects gathered from different pages in an Excel document. In addition, I want to add under each consultant a formula which fetch project...
I have successfully created several drop down lists however I am trying to display different drop down values based upon a selection.
Ex. In cell A3 it displays a drop down list with the values Keyword, Certification, Skills
If a user selects Keyword from cell A3 I want them to be able to...
On Sheet 1 I have:
A row of consecutive monthly dates (Jan-14, Feb-14, Mar-14, Apr-14 etc.) - let's call them A1-Z1
A row below with Sales figures for each month (1,2,3,4,5 etc.) - let's call them B1 - Z1
On Sheet 2 I have:
A row of dates which represent different period end dates which...
I currently have a spreadsheet with the following sheets which are tables, I also have a worksheet for every month and creating a monthly view of each day in their associated worksheet, I basically need a VBA macro to use the below information to construct a matrix such as below...
I work for an insurance brokers who sell policies on behalf of a panel of insurers. I've been given a spreadsheet containing sales data where each individual row represents an individual sale, and each column represents a different element of each such sale.
Hello all, I am new to VBA and really trying to improve. I tried looking a solution up, but couldn't really find what I need. Can anyone help me? or have an idea would be great! I really appreciate it!
I can't attach the xls, but here is how its presented:
Column A has the daily dates, column D...
I have a sheet called “Calculation” on which column E that contains (from row 4 below) approx. 50 numbers (results from a formula) and somewhere in these 50 numbers one row that contains the text “maximum” (also as a result from a formula).
This formula is for row 4...
I have what I think is a pretty simple question.
I have a column (A) of stock symbols (IBM, WMT, CAT). As the first part of this project, all I want to be able to do is to make a query to yahoo finance to get the name.
What I do is this.
1.Click on cell B1 and go to Data -> From Web
:) Good afternoon,
What i'm trying to do is to have a dynamic comparison between cell values. Here is the case:
In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column...
Hello Excel Masters,
after a few days searching and puzzling, it is time to ask the masters...
It is more of a project then a single question, but maybe you can direct me to the right page for certain aspects.
I have one master sheet 'Totals', built up like:
Customer Number Name...
I am building a Comp sheet that automatically populates a long list of stock tickers with a corresponding "sector code"
<TABLE style="WIDTH: 86pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=114 x:str><COLGROUP><COL style="WIDTH: 86pt; mso-width-source...
I have a Lotus spreadsheet that was created before I started here. I am attempting to recreate it in Excel. I have a Field I a dynamic field G6 which the user puts a date in. When they do this Field B10 needs to be populated with the number in the corresponding date field that is on sheet1 of...
I have a range where I want to find a cell address based on another function, like HLOOKUP or any other. But when I use HLOOKUP function as a 'refernce' argument in Excel's inbuilt function Cell(), it gives an error.
Is there a way, that I can find a cell address based on any of the...
I have just started VBA-ing in Excel, and feel I am way over my head. Any solution to the following would be greatly appreciated:
Basically, I have two two workbooks, let's call them data.xls, and model.xls
The model workbook needs to pull numbers from the data workbook. Basically the...