**-2**

votes

**0**answers

14 views

### macro to select certain cells and copy them to another workbook [on hold]

I am in way over my head and need help please.
I have a worksheet and I need to select only the cells in columns (B11:G24) but only if they have data in them. I then need to copy them cells and put ...

**0**

votes

**0**answers

18 views

### vba excel macro runtime error 1004

Dim lastC As Long
lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug
SourceRange.Copy
wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...

**-1**

votes

**1**answer

16 views

### How to apply formula in specific condition in excel

I am trying to use flags to use in formulas 1 ,0 . I want excel to put 1 every specific number of months (3,6,...) .
so if 1 applies in Sep ,then I want another 1 to be after (3,6,...) months. the ...

**0**

votes

**1**answer

31 views

### I need help for a quote form I am creating

Let me try to explain what I am trying to accomplish. Let's say that there are forty options available on a quote form. The customer only wants eight of the options. I would like to enter a ...

**0**

votes

**1**answer

8 views

### Page Break lines won't stay off for a shared Excel document

I have a shared Excel document on my NAS, and in Excel I go to options and disable Page Break lines.
However, when someone else opens the document, the page breaks reappear. When I reopen the ...

**0**

votes

**3**answers

40 views

### Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...

**0**

votes

**1**answer

44 views

### VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...

**1**

vote

**1**answer

34 views

### Matching and updating columns in Excel from two documents

I'm completely green with Excel, whenever I think there has to be a quicker/easier way I usally just GOOGLE it and sure enough I find an answer, fab!
Now I'm trying something a little more tricky and ...

**1**

vote

**1**answer

13 views

### Is there a way to do a partial text vlookup?

I am trying to vlookup partial text which will return a specific value if found within my data. I have a list of postcodes (zipcodes) and would like a vlookup to look up the first part of the postcode ...

**0**

votes

**1**answer

21 views

### how to cancel the focus change of cells in excel 2007?

When I move in the excel 2007 from cell a1 to cell a2, I sometimes just push the key too fast, I try to cancel it.I tried ctrl+z, however it wont' work, and some people say their version(2010)works ...

**1**

vote

**1**answer

27 views

### Excell formula for multiple pasts without repeating previous cells

I have a data set for 12 years of 4,380 days. I want to take the sum of each week. when I make a formula {=SUM(A1:A7)} and drag to drop button to the next cell it shows {=SUM(A2:A8)}. This is not what ...

**2**

votes

**1**answer

16 views

### Pivot table with two headers in MS Excel

I'd soo appreciate if someone could help.
My initial table looks like this:
Brand Period_1 Period_1 Period_2 Period_2
------------------------------------------------------
...

**0**

votes

**1**answer

20 views

### Have Pivot Chart show only some columns in pivot table

I have a data table. In the table I have some dollar amounts. I also have formulas that use lookups to group these dollar amounts into groups in the data itself. I then have a pivot table where my ...

**0**

votes

**2**answers

43 views

### Converting comma seperated values in multiple rows

I am in urgent need of importing huge data from excel to SQL.
one of the excel sheet contains data as follows.
ID Name Category Section
1 Books Stationery KG1,KG2,1
2 Pencils ...

**0**

votes

**0**answers

32 views

### Updating multiple pivot tables with slicers

I have a worksheet with about 15 different pivot tables, about 80% of them with multiple slicers. I've added rows to the data source sheet, however when I try to update the data source on the pivot ...

**0**

votes

**1**answer

8 views

### Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items,
with different information in all columns ,although certain columns might have duplicate information.
I can do conditional formatting and highlight the ...

**0**

votes

**1**answer

32 views

### Can't create a scatter chart from a pivot table in excel

No, excel. I can, it's just you that won't let me. *copy/paste, create chart, done*.
Is there a way to bypass this check? Copy/paste works, but I'd like a scatter chart from a pivot table to ...

**1**

vote

**2**answers

35 views

### Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet.
First Sheet:
(yes I need these merged cells)
Second Sheet:
Unfortunately Google ...

**0**

votes

**2**answers

21 views

### Cells show formula, not formula result

We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or ...

**1**

vote

**1**answer

35 views

### Formatting cells in EXCEL based on real world date

I am trying to format cells in EXCEL 2007 based on the real world date for due dates on my bills. I know how to do this using Open Office, however EXCEL does not use the same conditional formatting ...

**0**

votes

**1**answer

26 views

### Combining Two Differently Formatted Spreadsheets

I'm relatively new to excel and am having some issues comparing two sheets of data. We're looking at the benefits over the fiscal year by month. One spreadsheet has the project ID on the left, and the ...

**2**

votes

**3**answers

36 views

### Problems figuring out weekly scheduling and hours past midnight

This is a screenshot of what I have
What I'm trying to do is have the hours for each individual person posted as shown or a way that the hours can be posted like this and then have the total amount ...

**3**

votes

**3**answers

102 views

### Excel Scheduling - trying to calculate hours after midnight so they're not negative

If anyone can give me any type of help on why I have negative numbers instead 40, which is what it should equal please help. I'd be so grateful. Thank You!

**1**

vote

**1**answer

76 views

### Excel - Parsing data to template

I'm not sure if this is possible in Excel.
I have a sheet that looks like:
+---------------+-------+--------+-------+-------+-------+-------+-------+-------+
| | August ...

**2**

votes

**2**answers

31 views

### SUMIF/ COUNTIF (look up names from column 1 then sum numbers from column 2)

I need to look up names from column 1 then sum numbers from column 2. Some names in column one appear more then once. (The spread sheet I am working on has 7400 rows!!!)
Example:
Column A ...

**-1**

votes

**1**answer

21 views

### How to Add One column value to another coloumn value in bulk in excel

We have stock and price columns and we want to add stock number to price columns
For eg.
Stock(Column) 5
Price(Column ) 100
We want it be as below
Price ( Column )
5-100
So Final value for Price ...

**-2**

votes

**0**answers

45 views

### VB macro for excel

Coding a lil' macro so it pulls data from one book and paste's it into another book and I'm a little stuck. It copies data but only from the book I created the macro/button in, and not any other book.
...

**0**

votes

**0**answers

12 views

### how do you modify default excel hotkey in excel 2007?

how do you modify default excel hotkey in excel 2007? In word 2007, under office -option-define-menu you can define hotkey and change exsiting hotkey, while in excel i can't find it.

**-1**

votes

**0**answers

22 views

### MS Excel 2007 Copy Range Across Worksheets and Increment or Offset by 50 rows

I'm looking to copy and paste a list of names from Sheet 1 to Sheet 2 but space them out. For example, I'd like Sheet1!A6 -> Sheet2!A51, Sheet1!A7 -> Sheet2!A101.... Sheet1!A41 -> ...

**0**

votes

**1**answer

37 views

### Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20)
The 3 columns are each 1 digit of a 3 digit number.
Some of the rows have 3 digits, some are blank.
I need a way to return all the non-blank rows of 3 ...

**-1**

votes

**1**answer

26 views

### Formula to return values into a number of cells based on another cell's value. [closed]

If I have a cell (A1) value is "2" (set value)
& another cell (A2) value is "4" (number of cells in 1 column i want the set value to appear in)
How do I return the values in B1:B4 to all be "2"?

**0**

votes

**0**answers

3 views

### paste values in a cell based on two other cells

I have 2 columns(a,b) containing values. If cells in 'a' column have a string called 'major',then I have to paste 'important' in the corresponding blank cells of b.
New to vb.Need help
Thanks

**0**

votes

**0**answers

28 views

### excel - ask for input to be used as new cell values [closed]

I use excel 2007 and I want to create the following function:
At first I need to add a vba function button that prompts the user to add four different values, e.g. a name, a number, a date and an ...

**0**

votes

**2**answers

36 views

### Excel “IF” function has totally stopped working

THe "IF" function worked quite well a few months back. Needed to use it again and this time I keep getting the "something's wrong with your formula" window. I've tried everything : changing the commas ...

**0**

votes

**1**answer

22 views

### Financial Quarters from date

I have looked around for other solutions to this issue using the =ROUNDUP(MONTH(A1)/3,0) code.
However I am not using the standard dates for Quarters
Q1 - 02-Feb/03-may
Q2 - 04-May/02-Aug
Q3 - ...

**0**

votes

**0**answers

13 views

### I am having trouble pasting my data from a html* filtered notepad doc into Excel

I am copying supplier stock items from their website into Word, then copying it into a HTML file and opening it in Notepad before copying it to Excel in order to keep the format of the original text. ...

**0**

votes

**0**answers

22 views

### Excel Macro for preserving line breaks in cell text

I have an excel sheet containing text that I require copying and then pasting into a 3rd party application (bit like notepad).
I need to use a button to copy the text so it cannot be edited or ...

**0**

votes

**0**answers

37 views

### How do I make a function update dynamically when I make changes to the function in a “master” cell?

For example, column 1 would contain input data, and subsequent columns would perform actions on that data.
Row 1 would be the master row. All changes to the formulas in row 1 would be duplicated ...

**0**

votes

**2**answers

34 views

### How can I find max value for a text as unique identifier in Excel?

This is basically for an auction setup in Google spreadsheet.
Say there are 26 bidders A to Z and each bid 5 times with different values. I need to find the max value bid by each of them and display ...

**2**

votes

**2**answers

867 views

### How do I get “yes” or “no” in Excel if the information comes from “true” and “false”?

first of all, I have to point out that I am a German visiting this forum (I couldn't find anything useful on the German websites), so excuse my English if it is bad here and there ;-)
Here is my ...

**-1**

votes

**2**answers

66 views

### Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item.
Here is the data table:
Date Item Quantity Operator
01/01/2014 Item1 3 John
01/01/2014 Item2 5 ...

**0**

votes

**1**answer

26 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**0**

votes

**1**answer

32 views

### Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel.
Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...

**1**

vote

**3**answers

56 views

### IF formula returns wrong value

https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx
We have Excel 2007 (German) and vista ultimate.
I am trying Excel by building a roster but have run into a problem with the following formula.
...

**1**

vote

**1**answer

21 views

### Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...

**0**

votes

**1**answer

26 views

### Excel: Find a specific cell and paste the value from a control cell into it

I have two columns one containing the room number, e.g. B-CL102, the other containing a varying integer.
I want to enter a different, manually determined, integer in a third column.
Whether by macro ...

**0**

votes

**1**answer

27 views

### Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...

**1**

vote

**0**answers

40 views

### Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...

**1**

vote

**0**answers

26 views

### Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following:
48.8
4.19
(0.36)
4.52%
and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...

**1**

vote

**1**answer

37 views

### VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure:
Fill one cell with a formula, where arguments to ...