Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
btait1
 
Posts: n/a
Default Copy/Paste of QueryTable doesn't adjust relative parameters


Column A

1. Blue
2. Red
3. Green

A1 is a parameter to the query - on the QueryTable Parameters dialog, I
have "Get the value from the following cell: =Sheet1!A1" Note that this
is a relative reference, not $A$1. When I copy the whole QueryTable and
paste it elsewhere on the sheet the parameter of the new QueryTable is
still set to A1, rather than A2 for example. How can I create the
QueryTable so that the parameter references are updated properly when I
copy the report?

Please note...I am not VBA literate - yet:) So I am looking for a
solution here that does not require VBA - or if it does, would be
simple for a complete novice to implement.

Thanks in advance!


--
btait1
------------------------------------------------------------------------
btait1's Profile: http://www.excelforum.com/member.php...o&userid=27685
View this thread: http://www.excelforum.com/showthread...hreadid=472018

  #2   Report Post  
btait1
 
Posts: n/a
Default


Calling all query experts....


--
btait1
------------------------------------------------------------------------
btait1's Profile: http://www.excelforum.com/member.php...o&userid=27685
View this thread: http://www.excelforum.com/showthread...hreadid=472018

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want chart source data to be relative references, not absolute. Bob Mc Charts and Charting in Excel 1 April 7th 06 02:53 PM
auto adjust columns in a pivot jenn Excel Worksheet Functions 0 August 9th 05 07:46 PM
automatically adjust row height in excel 2000 David D Excel Discussion (Misc queries) 2 July 26th 05 08:05 PM
How do i make a macro "relative" to cell? Art Nittskoff Excel Discussion (Misc queries) 4 June 22nd 05 07:05 PM
Relative Macro Help on Keystrokes Neal Zimm Excel Discussion (Misc queries) 9 December 15th 04 01:31 AM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"