I currently have a large list of data, but to simplify, here's a simple example:
I currently wrote cell C5 as = J5
I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5
However, I want it to...
I have a workbook that pulls data from another workbook.
At present both workbooks have to be open for the data to pull through.
What I am wanting is a way to pull the data from 'workbook1' to 'workbook 2' without 'workbook 2' being open.
I cannot use vba as I also have another workbook...
I have 3 cells, each cell has a value, 1, 2, 3
The cell value is related to a score, each score located in another cell, 10, 8, 0
To pick a value, the user has to change the cell colour, for example the user picks the cell with 1 and shades it any colour
Then the formula needs to pull in the...
I have a three column table, one column with a name, another with a date/time timestamp, and a third is whether that row is completed.
I basically need to pull through a name to another sheet, but it has to be the oldest uncompleted. I just can't suss how to do it!
I have this data, it has too much details in one column. I'm trying to write a formula that will find only certain contents based on cell A on another tab. If it matches whats in one of those cells, then pull that name or details. How would I go about writing a formula for this?
I looked up...
Hello, I am trying to create a sheet in Excel to pull Hours from another sheet to upload into a system as a CSV file. I need a formula for hours that would pull in the Reg Hours and then say if the Overtime cell has a value then it will make a second line for that same employee and pull in those...
I currently have 2 sheets of serial numbers sheet 1 has all of the new serial numbers on it and sheet 2 has both old and new serial numbers on. I am currently trying to bring all of the old serial numbers into the sheet 1 but due to the nature of index match and vlookup I am only able to pull in...
I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it.
Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...
I have two different spread sheets with categories and I want to pull the category ID of sheet B into sheet A. While they have similar names they are not identical so I cannot do a simple VLOOKUP or other similar method. What I want to do is search if any part of the category name in sheet A is...
I have a spreadsheet with Positions down the side and Steps across the top and the rates in the columns. I need a formula that will pull the rate for the first available step into one column. So for receptionist, it would pull the Step 1 rate, for Technician it would pull the Step 3 rate and...
So my data from where i want to pull the sum range contains alphanumeric values in like "GS08, GS09, GS10"
The criteria1 range is the range for unique client reference nos. in cells A2:A2688. Criteria1 is to pull each inidividual client reference no. for eg. 64852345.
I have one file with two sheets. One sheet one in row one I have one column as name, column two as a number and column three as a month of the year. On my sheet two I have the same three columns. How can I pull just a single month (like Jan) from the sheet one to sheet two? Doing this using a...
I want to us * in a drop down list to return all results of a query. This is not working for some reason. The data has "y", "n", and i want to use * to pull all results when I change the drop down selection. Any ideas why?
Hoping there's an easy formula for this as I am having a blank moment.
So the below is a simple example of what I am trying to pull through in to column E.
I would like to look up multiple "Item Number" which are the same, sometimes theres 2/3/4 of the same items.
I would then like...
so i have in column A...booking point...and under that...x376x, x324x....
in column B, i have product type....under that, TR Swap
for whatever reason, when i pull this data in using a vba macro based on the criteria above, it's also pulling in booking point "x324xVAL," but i dont want that...i...
I have this simple VBA to send the sheet as an email when a button is pressed.
ActiveWorkbook.SendMail "email@example.com", "Leader Standard Work for previous week " & Date
How would I change this to pull the email address from cell A10 on tab "Directions"...
I am looking to pull values from an assortment of invoice formats that will populate a summary sheet (example below). Though location of "Fund" and "Amount" can vary within each invoice (and they don't always begin on row 1), they always contain the same headers. Is there a way to...
I'm using the Analysis tab to pull things from SAP BI - for whatever reason if it goes over a certain number of records, it either disconnects me from SAP Business Objects, or gives me a "no data" message.
What I'm trying to do:
I'm trying to pull all orders for all accounts, so I can...