Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 477
Search took 0.04 seconds.
Search: Posts Made By: DanG
Forum: Excel 06-18-2019, 01:27 PM
Replies: 7
Views: 3,760
Posted By DanG
Re: Tables: structured references

Not everyone has Access on their computers and it's easier to pass around a workbook. But I'm with you on that.

Tables seem to be very cool and have a lot going for them, but as I'm finding out...
Forum: Excel 06-18-2019, 12:51 PM
Replies: 7
Views: 3,760
Posted By DanG
Re: Tables: structured references

Thank you June7.

I took your advice and renamed GA# to GANum...thank you!

Your example is on the right path, I have tried different variations of it, but can't get it to work. The best I can...
Forum: Excel 06-17-2019, 02:35 PM
Replies: 7
Views: 3,760
Posted By DanG
Tables: structured references

So I'm trying to understand working with tables by using structured references and need a push.

How would you write the formula below using only structured reference? The table name is "Activity"...
Forum: Excel 06-14-2019, 10:12 AM
Replies: 1
Views: 282
Posted By DanG
Re: Sorting Tables

I think I found the solution.

Apparently, tables has an issue with hard references sometimes. So using a dynamic reference seems to be a good workaround, at least it worked for me.

I used this...
Forum: Excel 06-14-2019, 08:46 AM
Replies: 1
Views: 282
Posted By DanG
Sorting Tables

Hello,

I am new to working with tables and have an issue when sorting. The issue seems to be related to the relative positioning when referencing an adjacent cell. Before sorting, the top cell and...
Forum: Excel 01-07-2019, 02:25 PM
Replies: 18
Views: 1,033
Posted By DanG
Re: Magic formula appears

I see in your profile you're retired....keep giving answers like this and you'll find yourself working again :)....I wouldn't wish that on anyone, thanks again!
Forum: Excel 01-07-2019, 12:06 PM
Replies: 18
Views: 1,033
Posted By DanG
Re: Magic formula appears

Mystery solved!

Thank you very much, kind of a neat trick.
Forum: Excel 01-07-2019, 08:19 AM
Replies: 18
Views: 1,033
Posted By DanG
Re: Magic formula appears

Please see the attached example.

Make a new entry into column 2 & 3 and you will see a result appears. The thing is there is no formula in column until you enter into the other columns.

I am...
Forum: Excel 01-06-2019, 02:12 PM
Replies: 18
Views: 1,033
Posted By DanG
Re: Magic formula appears

Not that I see, I will upload tomorrow as it's on my work computer.

Sent from my SAMSUNG-SM-N910A using Tapatalk
Forum: Excel 01-05-2019, 03:46 PM
Replies: 18
Views: 1,033
Posted By DanG
Re: Magic formula appears

Thank you, the thing is there is no formula. A formula only appears in Columb 1 when Columb 2 & 3 have numbers entered into them. Otherwise it is completely empty.

It's magic I say! There is no...
Forum: Excel 01-04-2019, 10:21 AM
Replies: 18
Views: 1,033
Posted By DanG
Magic formula appears

Hello,

I have an existing worksheet that has a table of data and column 1 had no data or formula in it unless numbers are entered into column 2 & 3.

I have seen this before but can't remember...
Forum: Excel 03-26-2014, 11:50 AM
Replies: 3
Views: 11,380
Posted By DanG
Re: I need the screen to move to the selected cell

I know this has been dead for a loooonnnggg time, but I was looking to soldve this problem today...and here it was!

Thank you!
Forum: Excel 01-29-2014, 09:54 AM
Replies: 1
Views: 1,583
Posted By DanG
Re: Excel 2003 to Excel 2010 VBA Error

Solved!

The problem was "FileFormat:=xlExcel9795", I changed it to "=xlExcel8".
Forum: Excel 01-28-2014, 02:09 PM
Replies: 1
Views: 1,583
Posted By DanG
Excel 2003 to Excel 2010 VBA Error

Hello,

We just converted from Excel 2003 to 2010 and I am getting the following error "Error 1004 - Method 'SaveAs' of object_Workbook failed".. The code worked fine in 2003.

The macro uses the...
Forum: Excel 01-14-2014, 07:15 AM
Replies: 7
Views: 1,061
Posted By DanG
Re: Partial Path to worksheet from a cell

[QUOTE=GSSDevelopment;1322685]
If you are up for a bit of manual work, you can set the formula cell equal to
="=SUMPRODUCT(--('C:\Documents and...
Forum: Excel 01-13-2014, 01:47 PM
Replies: 7
Views: 1,061
Posted By DanG
Re: Partial Path to worksheet from a cell

I'm taking that formula and dragging it down in the master sheet, in the target the will be B2 through Z2 not F2 (like my sample had).

Is it not possible to just reference "A2" as I have described...
Forum: Excel 01-13-2014, 01:17 PM
Replies: 7
Views: 1,061
Posted By DanG
Re: Partial Path to worksheet from a cell

Thank you for your reply,

This particula formula is one of the few that can be read from one workbook while the other (target) is closed (as far as I know).

So the idea is to have a collection...
Forum: Excel 01-13-2014, 10:30 AM
Replies: 7
Views: 1,061
Posted By DanG
Partial Path to worksheet from a cell

Hello,
I would like to modify the formula below to get the "Baker, Tom" part of the formula from a cell like "A1" and am not quite sure how to do it?

Row A contains the names of the other...
Forum: Excel 10-08-2013, 11:51 AM
Replies: 10
Views: 1,531
Posted By DanG
Re: My Crappy Code Needs Fixing

Thanks namliam, that makes sense!
Forum: Excel 10-07-2013, 09:09 AM
Replies: 10
Views: 1,531
Posted By DanG
Re: My Crappy Code Needs Fixing

namliam - You know, sometimes things come accross a bit harsh in writing, I'll give you the benifit of the doubt on this one :)
Your input, to me anyways, was a bit abstract for my skills and you...
Forum: Excel 10-04-2013, 01:39 PM
Replies: 10
Views: 1,531
Posted By DanG
Re: My Crappy Code Needs Fixing

Sorry for the confusion, never have been good at multitasking, I am working in Excel 2003 :)

But, we will be moving to Office 2010 next year, so maybe there is hope...in the future.

I don't...
Forum: Excel 10-04-2013, 06:19 AM
Replies: 10
Views: 1,531
Posted By DanG
Re: My Crappy Code Needs Fixing

Thank you for your reply!

I am using Access 2003, no ribbon.

Code is needed because this is part of an add-in that multiple users have installed on their computer. Then they download the client...
Forum: Excel 10-03-2013, 02:27 PM
Replies: 10
Views: 1,531
Posted By DanG
My Crappy Code Needs Fixing

Hi,

The crappy code I made below is designed to condisionaly format on 2 columns, "Group Nmber" and "50/50 Category". Under "Group Number" I want all rows highlighted grey that are "or" contain...
Forum: Excel 04-11-2013, 02:24 PM
Replies: 2
Views: 771
Posted By DanG
Use a variable from one function in another

Hello,

I'm just trying to get the concept (not on a project).

In the code below, the first function defines a range and calls it "myrange". I then want to use that range in another fuction (2nd...
Forum: Excel 03-21-2013, 01:09 PM
Replies: 13
Views: 1,255
Posted By DanG
Re: Finding Value Within a Series

Sometimes your just have to go with the sloppy solution. I just made 2 conditions/versions out of it and it works fine now.

I thnk in the end your solution was proper, I think there is a problem...
Showing results 1 to 25 of 477

 
Forum Jump



All times are GMT -8. The time now is 03:28 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World