Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Wicca
  • Content: Threads
  • Order by date
  1. Wicca

    MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another

    The problem is a "simple one" I am sure. I am using the MAXIFS formula but it is not transferring all the data. I have tried to put an explanation in the attached spreadsheet. While there are about 30 tabs to the spreadsheet I have left two open. The rest I dont think are relevant to the case...
  2. Wicca

    Excel 2010 - How do I put data into a protected sheet?

    I know this may sound like a silly question however, I have a manager that insists on overtyping formulae. I have a 600 line by 30 column speadsheet and every 4th column contains a link to a seperate worksheet. eg =Otorohanga!$C4 =Cambridge!$C20 =Rotorua!$C344 Every time he uses the...
  3. Wicca

    Cells formatted ACCOUNTING don't work (simple subtraction calculaton)

    I have a series of cells that are all ACCOUNTING Formatted A B C D $43,622.43 $42,770.78 $851.65 $0.00 $20,089.53 $19,348.89 $740.64 $- $23,465.76 $23,087.19 $378.57 $- $29,706.87...
  4. Wicca

    Excel. Stop/Start Macro

    I have a macro that gets data from a SCADA system on the same computer. However the macro runs faster than the download occurs and I get the error #N/A. I have watched it happen and cannot see how to overcome it. I tried an application.wait with a 2 sec and with a 10 sec delay but the whole...
  5. Wicca

    Excel - Start Error

    Merry Meet, I have a funny problem When I open my Application and run the macro I get #N/A message in the cells However if I run it from the ALREADY open state I get the correct data The data is being lifted from a PLC and place into a Temporary spreadsheet How do I overcome this problem...
  6. Wicca

    Thank You

    Probably an inappropriate posting but will give it a go anyway Im just a dumbass user so couldnt figure out how to get to compliments page and post there Just wanted to say THANK YOU very much for this site. I have visited it so many times in the last week and got so much information You...
  7. Wicca

    Excel 97 - Today() - Month as ActiveSheet.name

    Merry Meet, As I am sure many of you do, I have 12 sheets named January thru December. And, again, as I am sure many of you do I manipulate the data within those sheets. Question? After I have been manipulating data like a good the good little boy I am, HOW do I get it to go back to the page...
  8. Wicca

    Excel - Run macro at set time

    Greetings from New Zealand, First I apologise for being a vendor (I hit the wrong option when I signed on). Im actually a very very new programmer. Well actually Im a user that has been dumped with the programmers job and no training....so sorry for silly questions. 1. How do I start an excel...

Part and Inventory Search

Back
Top