Hey there, :confused: I am currently working on a project which required me to do a project using macro. I have to create a macro which enables me to join up...

I have a number of Excel files on a network server which it is mapped on my PC as the 'H' drive, however for some users this drive is mapped as their 'K'...

=DSUM(Membership,Membership!$C$49,C1:C3)+DSUM(Revenue,'Revenue Projects'!$D$2,C1:C3) I'm trying to adapt a budget worksheet from another non-profit for our...

Is there a quick formula to apply a protection code for multiple sheets without having to protect each sheet one at a time?? Actually this appears to be quite...

:confused: Hi, what am I doing wrong with the following formula: =countif(sheet1:sheet31!E6:E35,"=1") FOR some reason this formula fails when I use the...

I down loaded a calendar template from M/S but I want to change the numerical dates to an other font. I can change the numbers one at the time but I'm...

I am sorry if this is a stupid question but here goes . If I type in dates as 010106 it gives me 01/09/27 This was raised in an earlier Question I tried the...

How can I automatically change data entered in cell A1 (32454521) into a dollar amount in cell A2 ($16.25)? Thanks for your guidance!

I'm really new to excel and this forum, so please bear with me... What I'm looking to do, is having one "week-sheet" and one sheet for every workday, and...

I have an expenses sheet set up as follows: A/status B/date C/expense type D/amount 1 allowed 05/07/06 ...

:confused: Hi, I have spent countless days trying to find a formula that will allow me to find duplicates across Multiple Sheets within a single workbook. All...

I want my Excel file to have 2 sheets with 2 tables. I want the 2nd Sheet’s Table to be LINKED to the 1st (so when I update the 1st, the 2nd...

I am studing Excel online but the practice templates will not download; I am following a hyperlink to the...

can I enter a day into my date & year and then drag to auto fill if so how?

I live in Ecuador, here we use centimeters for paper sizes and margens. So I need to change the original inches, to cm.

Hi All, Okay i have an Excel Spreadsheet with 3 Sheets inside this. 1) Summary Sheet: is what i would like ALL the data to go to once i press the Macro...

I have found a template in M/S excel download that I would like to use but how do I change the dates. The current template is dated 11/1/2004 -11/14/2004 The...

how to automaticaly copy the value of B3 to E5 while inputing value in B3?

I entered a row into a template sheet. Where there should be 1 cell there is now 2 cells in one of the rows and when I drag down to auto fill, it is...