Hi, I am new to excel and i am trying to paste some data from a table this table is in sheet 1 of my workbook. What i am not able to do is whenever i paste...

Using Excel as a Db, how may I copy / paste a sub set? I currently get the entire Db pasting when trying to copy/paste desired rows (the others being...

When I paste a table from Word to Excell the data that appears on line 2 in Word appears on line 7. I cannot pull the file up to line 2 because it is...

i'm tryiing to copy rows in a workbook that also contains hidden rows. When I do this, all the hidden rows are copied as well. is there a way to only copy the...

Hello. I'm a not a total newbie, but did encounter a problem today. When attempting to copy a table from a webpage into Excel (which I have previously done...

I have prepared a spreadsheet that has a macro(recorded) in it that when invoked, opens another excel file. Here is that code: Workbooks.Open Filename:= _ ...

Dear community I am a retired accountant, and have used Excel for many years, including power user, macro and VBA development. I would like to specialise...

hello, newer to excel 03, i have data from my ER, i cant figure how to pull out the number of patients per hour. i can do it manualy but this is tedious....

My first macro using XP, Excel 2003. During the Recording of a macro, what syntax/keystroke is required to 'pause' a macro so as to allow input of data into...

In Excel, where can I get examples for Macro's that pause for input, then continue?

Greetings all, OK, I posted a few days back with a question about a Pay Stub and getting it to auto update Year to Date totals, and the answer I got was great,...

Hello, Does anyone have an Excel spreadsheet which will calculate simple PAYE Income Tax on a month by month basis. I've Googled and Ask-ed but am getting...

I've been working on a payroll workbook, and most everything is working the way I want it to except the YTD totals. I want to update the YTD cell with the push...

With a rang of cells equaling 90,(a1,b1,c1 and so), how do you get the calculating to stop at 40. Useing Excel 2000

I have downloaded the payroll calculator in excel, but it has U.S figures, I for the life of me can not get it to work correctly with canadian figures, can...

i have an .rpt file converted to pdf. its in the form of rows and columns. can i use this in excel... i trie the usual methods.. but cudnt convert it.... plz...

Hi I run Win2K with Excel2K. I have a validation box that I select a letter from. ie: A I then hyperlink this letter to a PDF file on my local drive. When...

One column is filled with dates but in each cell one can see the dates in number format (though the formatting has been selected as date type) and at the...

Hi all, I am a sole trader and want to calculate my car running costs in Pence per mile taking into account fuel, servicing, tyres etc. I have looked at the...

Gordon, the trouble is not that I can't do as you've suggested, the problem is that almost all the columns are showing errors because of the tiny roundings up...