0
votes
0answers
13 views

Changing the number in Excel each time I print (and for a range)

Basically I want to add an addittional input box for range printing. Change the code from this thread: Changing the number in Excel each time I print to include another input box to determine the ...
0
votes
0answers
42 views

Excel chart copying whole sheet into a new workbook - references to hidden rows are copied as absolute link

When in Excel 2013 I copy and rename whole sheet containing a chart into a new workbook, my references to series value ranges, axis labels etc., that have data in hidden rows, are not copied as ...
0
votes
1answer
46 views

Excel: How can I copy cell contents from multiple sheets at once?

I would like to select cells in each sheet in my workbook and then copy them all at once, is that possible? Or even better, if I could mark those cells (group perhaps) so that I could get the SUM of ...
0
votes
1answer
322 views

excel macro to look up data from a database and copy it to another excel file or sheet

I have an excel file which looks up and calculates data for a given date. It works as follows: You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...
5
votes
4answers
10k views

How to insert empty rows in Excel 2013 when I have copied rows in my clipboard?

This seems like something which should be painfully simple to do but I can't figure it out. So with an empty clipboard I can right click on a row header and say insert row, no problem, it inserts a ...
0
votes
1answer
310 views

Excel - how to copy all colums in a row based on a condition

I'm new to macros and hope somebody can help Trying to make a report from a datasheet that meets some conditions. I need to fetch all the data (cells) in a row e.g. that meet the condition <1 in ...
4
votes
3answers
4k views

Copy/paste filtered column in Excel - error message

In short, I have filtered a worksheet by column A, and I want to copy/paste from column B to column C. Obviously I don't wish to copy/paste values from rows that were filtered-out here. The above ...
0
votes
1answer
722 views

How can I copy cells in Excel 2007 and paste with formatting

I am wanting to be able to copy cells in a worksheet and paste them elsewhere in the same worksheet while maintaining the original formatting. I also want to be able to paste into Word and Outlook ...
6
votes
2answers
2k views

How to change the delimiter when you copy from Excel and paste to notepad

I would like to copy cells from Excel, and paste it to notepad with comma as delimiter, in stead of tab(which it is). Is there any way to do this without doing a replace in Notepad or saving the ...
0
votes
4answers
4k views

Copying a hyperlink so that it works with a series

OK, this should be a no-brainer, but I cannot find anyone to help me with this: Example A5-K5 On worksheet 1 contains info relating to one specific item. I want to have a hyperlink in L5 taking me to ...
5
votes
2answers
2k views

How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica. How to have a ...
0
votes
1answer
532 views

Excel 2003 “SHIFT+Copy” functionality - where is it in 2010?

i use the 2003 "SHIFT+Copy" function very frequently - eg every monthly. I have thus far been unable to find it anywhere in 2010 and have spent about 10 minutes searching MS on line. Does anyone ...
1
vote
1answer
711 views

Copy & paste a cell along with its name in Excel

Is there a way to copy a cell that also has a "name", and paste it somewhere else so that the new cell also has the same "name"?
3
votes
5answers
25k views

Excel: copy cell formatting in equation

If I make an equation: ' on cell A2 =A1 Is there a way to make A2 have the exact same formatting as A1 and not just the value? EDIT: i.e. I want a FORMULA that copies both the value and the ...