Sep 17, 2018

Custom Footer From Cell

I would like to create a custom left footer using info in a cell...
Using Cell C1 on each individual sheet.
I do not want a macro that I have to run myself, but code that will update every time I go to print it.

You may find it helpful to sometime place the contents of a cell into the footer of a worksheet, and to have the footer updated every time the contents of the cell changed. The easiest way to do this is with a macro. The following is an example of a macro that will place the contents of cell A1 into the left side of the footer:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    ActiveSheet.PageSetup.LeftFooter = Range("A1").Text
End Sub
The macro is run every time Excel does its normal recalculation—meaning every time the contents of any cell changes or someone presses F9. If you want the contents to be in a different part of the footer, you can change LeftFooter to CenterFooter, or RightFooter.

To apply any formatting to the footer other than the default you will need to add special formatting codes, and you can also use special data codes that Excel recognizes for headers and footers. Both the special formatting and special data codes are quite lengthy and have been covered in other issues of ExcelTips.

If you are working with a very large worksheet, then changing the footer every time Excel recalculates may unnecessarily slow down your computer. After all, the footer remains invisible to the user until such time as the worksheet is actually printed. In this case, you simply need to rename the above macro to some other name that you would then manually execute as the last step before printing a worksheet.


If you would like to know how to use the macros described on this page (or on any other page on the ExcelTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8965) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Putting Cell Contents in Footers.

How To Open A JPG Picture On IPad

Cannot open IMG-7248-JPG picture on IPad.

can't open jpeg attachment on iPad or iPhone, only on desktop,computer. Is there a setting a need to change?

If images are not being displayed when you view your emails with your iPhone, try the following tips to resolve the issue:
Try exiting out of the message and going back to your inbox. Then tap the message one more time to see if it loads properly.
The application to view email does place a limit on the amount of content it will download initially. If the email is too large, scroll to the bottom of the message and look for a button labeled "Download Full Message" or something similar to that. Select the button to let the message download completely. The images should now appear.
*Note: To modify the settings on your iPhone to allow images:
Open the settings app.
Select "Mail, Contacts, Calendars."
Set the "Load Remote Images" to ON.

Mar 7, 2016

Food makers see the snack in everything

Hidden treasure. Step-by-Step. The delicious, colourful 
layered cake with a hidden sweet centre. [Photo/IC]

There are no meals anymore, only snacks.

As around-the-clock grazing upends the way people eat, companies are reimagining foods that aren't normally seen as snacks to elbow in on the trend. That means everything including grilled chicken, cereal, chocolate, peanut butter and even Spam are now being marketed as snacks.

Some are trying to jump into the party by playing up protein. Meat processing giant Tyson launched Hillshire Snacking this year with packs of cut-up chicken that people are supposed to grab and eat with their hands (120 calories per pack). Canned meat maker Hormel is testing "Spam Snacks," which are dried chunks of the famous meat in re-sealable bags (220 calories per bag).

People with a sweet tooth aren't being forgotten. After years of slumping cereal sales, Kellogg recently introduced Kellogg's To Go pouches, which hold slightly larger pieces of cereal the company says were "specifically created to be eaten by hand" (190 calories per pouch, which is comparable in size to a bag of potato chips).

Even Hershey is trying to become more of a snacks player with "snack mixes" that seem like trail mix, except with Reese's peanut butter cups and mini chocolate bars (280 calories per package).

"People are snacking more and more, sometimes instead of meals, sometimes with meals, and sometimes in between meals," says Marcel Nahm, who heads North American snacks for Hershey.

He says Hershey's research shows some people snack "10 times a day".

Mar 5, 2016

Why Are Windows Defender And Antivirus Popping Up As Off?

Hey im having a weird issue where every couple of hours a notification will pop up saying my windows defender or webroot(my actual antivirus) are shut off and that their spyware protection is shut off. But, ive been checking both of them as soon as that pop up shows up and they both seem to be working properly. Also their have been a couple random screenshots popping up and saving to my onedrive. Is this the sign of any virus? ive been running scans but everything is showing up clean. Some other info that might prove useful: i did take a screenshot earlier today, and this was my first time ever taking one. Im using an external mechanical keyboard and never had any issues with it. Also i lent a class mate my computer for a quick moment a couple days ago, before that i never had any issues.

VBA Code To Run On Entire Workbook

Below is the code from that only works on one sheet ("1")... I would like it to to work on the entire workbook. Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$5" Then If IsDate(Target) Then Sheets("1").Cells(23, 1).Insert Sheets("1").Cells(24, 1) = _ "Pre-Construction Meeting: " & Target.Value Sheets("1").Cells(25, 1).Insert End If End If If Target.Address = "$C$6" Then If IsDate(Target) Then Sheets("1").Cells(23, 1).Insert Sheets("1").Cells(24, 1) = _ "Anticipated Start Date: " & Target.Value Sheets("1").Cells(25, 1).Insert End If End If End Sub

Oct 8, 2015

Surface Book: Microsoft anachronistic ambitions

Win10 hardware product release, Microsoft product. Outside pleasantly surprised at the retreat is not only for six months out of the company's new flagship, nor is it represents the future science fiction world HoloLens virtual reality technology, but the Surface after Surface Pro to launch a new product line: the Surface of the Book. Surface restoring ancient ways of the Book is a "reactionary" products. According to the conference, which is home to the Microsoft laptops. This laptop computer is moving under the big trend, Microsoft confronted with confused looking for direction, purge Windows camp. When facing the Android mess it with the Google launched the Nexus approach. Windows camp OME manufacturers themselves into confusion Gartner and IDC figures released in July this year show that the second quarter of decline in PC sales suffered the biggest in two years. Gartner, points out that in the second quarter of this year, manufacturers shipments at 68400000 m, fell 9.5%. And IDC is not optimistic, 66.1 million global shipments (PC sales only, not including tablets) compared with the same period last year, fell 11.8%. In fact, the trend of decline in PC sales began as early as 2008. In January 2009, IDC has sent data, says the Asian PC shipments fell 5% in the fourth quarter of 2008, is the first decline in 10 years. Mobile wave erosion, and PC sales decline to Microsoft has brought unprecedented pressure, the traditional Windows OME income continues to decline, Microsoft to risk life and death. Compared to the prosperity of the Windows 7 times before entering after doing/Win8.1 era, Microsoft OEM authorized sales in winter. At the same time, moving the weakness and doing/Win8.1 in product failure gave apple an opportunity, especially the traditional PC market downturn environment, Mac upturn in sales. Extension effect, caused by the iPhone users are proud of having a Mac, this phenomenon is more to the Windows broken. In this case, the OME manufacturers Windows camp ushered a confused. Deformation, super this, android, Windows seal and so on various products emerge in endlessly. While exploring spirit is commendable, but due to doing/Win8.1 too failure, even if these products in a certain time to grasp the customer pain points, also still powerless. In their own way this exploration has brought greater trouble, OME manufacturers like a headless fly, no one knows what is really in line with the experience of the classic, no one can seize the trend of the future at the same time in the software and hardware level and trend. This is exacerbated by Mac and Windows contrast, the decline of Windows and weak. An iPhone and a Macbook became a lot of people at the top end of the standard, so that the last Surface Pro3 conference, the journalists use Macbook shorthand, to Microsoft struck a big ear. The ambition behind Microsoft atavism Some analysts believe that Surface, the Book is a perverse products, with Microsoft mobile first, runs counter to the cloud first strategy. To some extent, Surface Book such a product is indeed "reactionary", on the one hand, modelling restore ancient ways, will traditional laptop with touch screen, stylus design to sell; On the other hand, lack of portability, and Surface Pro, compared to such a successful product line on the mobile office level. But to his surprise, this was once a product is born just to widespread acclaim. A picture of a Microsoft conference broadcast live, Surface release of the Book is the most exciting time foreign media reporters. Microsoft executives and on-site journalists stood up and applauded, even a surprise, salute to Surface Book. Domestic digital industry, the editor of the students even in the circle of friends said the phrase: finally have a have a pretend bility of Windows laptop, never feel inferior in front of Mac users. Buy buy buy, it has become the domestic many to understand the product of the consumer's consistent voice. Behind the Surface Book anachronistic, actually reflect the change in today's market as well as Microsoft's ambitions. 1, the right of the mobile market Over the years, the so-called mobile Internet's point of view in both Microsoft and Google in the mobile market after the two world became the mainstream, although had many analysts had vociferously iOS and Android to carve up personal PC market, Microsoft Windows leading to Windows "threw it into the dustbin of history". But iOS and Android still there is no breakthrough on productivity tools this level, people gradually realized that the traditional notebook computer is where they should return. This from the classic Thinkpad regression design this event this year. Design association, vice President David Hill in June on his blog published a set of ThinkPad classic concept design, the idea is "new wine in old bottles", let now fittings used once appearance design, let the wind restoring ancient ways is blown into the ThinkPad. To some extent, this is also a rebellion in the current mobile trend. So we see that the device Pro with the new Office suite and handwritten pen, focus on doing a for Office productivity tools. Google's new tablet Pixel C for the first time with the keyboard, also try to do a light office tools. The domestic market, also in the flow of a Remix is to explore how to use the android do a productivity tools. Do a productivity tools, it is Microsoft's most good at doing, had to Surface represented Pro3 and Surface3 Surface series products but also a great success that a truth: Windows is the most efficient productivity tools. The return to classic form, Surface Book is actually tasted Surface Pro3 and Surface3 after sweeping new attempt to regain control of the market. 2, Microsoft hidden Nexus thinking Nexus series products as Google's son, had been shouldering the dominate the market, set up the important role of benchmarking. The Microsoft Surface the intention of the Book and the Google Nexus almost the same. Surface the Book on the one hand, bear the education OEM manufacturers how to do a elegant Windows laptop, on the other hand, is directly with the Macbook for mark, rob apple notebook market in high-end users. Classic Thinkpad regression design to the Surface from the beginning of the Book publishing, PC camps shall be over chaos, also found the stable fulcrum. Under the background of basic homogeneity of hardware, the superiority of Microsoft's intention with the aid of productivity, to launch the Windows platform on the fixation of the performance and design of living in the town of mesa product, keep weight calculation and the enterprise market, with many PC makers in kandy product mode to promote a unified process. In the latest Microsoft in the third quarter of fiscal 2015 earnings report, this reflect more obvious. According to the report content, Microsoft Windows OME this quarter revenue by 22%. Especially after the end of Windows XP support, a dramatic escalation of Windows, and Windows 8.1 pro OEM's income was reduced by 19%. OEM drop in revenue for Microsoft, is not a bad news. The profit pattern of the original are broken by Microsoft, Microsoft in the Pro conference, with the productivity of the Pro endorsement for Ofiice, everyone thinks everyone thinks Microsoft and apple after years of slay love shaking hands. From the Surface of the helm Panos Panay yesterday as revenge for the Macbook has done several contrast, the Pro has completely turned into Microsoft office software used this tool, Surface Book and Surface Pro4 hardware product is represented by Microsoft's aim. Postscript: Disadvantage on the Microsoft mobile end instead of triggering the integration of the whole platform. With the apple from the mobile end gradually eroded to the desktop system, Microsoft is through traditional advantages of the PC gradually enhance the originally weak mobile terminal. Believe in the common application development advance, Microsoft will usher in a new competitive landscape.

Oct 7, 2015

Kaka return to Brazil and Chile's World Cup qualifier preparations

The Brazilian national team in early October will be two World Cup matches, selecao will against Chile in San Diego on October 8, on October 13, in the home game against venezuela. Kaka replace injured out of the library's national team has included in the squad.