Re: [MS_AccessPros] Manipulating a worksheet

 

Dear hgprod2002 (name?)

This forum deals with working in Microsoft Access, not Excel. If you have linked the spreadsheet into an Access table, you can eliminate unwanted columns using a query on the linked table.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
http://www.viescas.com/
(Paris, France)

On Dec 19, 2016, at 11:41 AM, hgprod2002@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have created an excel spread sheet to help me calculate material amounts needed for a project but only typing in room dimensions. However I need help in figuring out how to eliminate unwanted fields for total job calculations and report printing.

Any suggestions?

------------------------------------
Posted by: hgprod2002@hotmail.com
------------------------------------

------------------------------------

Yahoo Groups Links

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___