A
Andrew Davroche
How do I see the answer to my question?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Maybe you haven't got one yet.
Watch for responses to your double-posting in microsoft.public.excel.misc group
Gord Dibben MS Excel MVP
Watch for responses to your double-posting in microsoft.public.excel.misc group
Gord Dibben MS Excel MVP
A
Andrew Davroche
Thank you for that. I do not know how to get to the
microsoft.public.excel.worksheet.functions area but I am sure I'll find out.
This is all new to me.
If I should only do one posting for a problem how do I know where to place
it? It is not always obvious to me.
I have Excel 2003
My original question was:
I have a "summary" worksheet which takes data from a "data" worksheet. The
"data" worksheet has rows for information as "Sales", "Revenue" or "Margin"
and columns for the months. Each month I want to move the links from the
"summary" sheet to the new month column in the "Data" worksheet - from July
to August etc. The new month is the next column to the right. How do I do
this without moving each link individually?
microsoft.public.excel.worksheet.functions area but I am sure I'll find out.
This is all new to me.
If I should only do one posting for a problem how do I know where to place
it? It is not always obvious to me.
I have Excel 2003
My original question was:
I have a "summary" worksheet which takes data from a "data" worksheet. The
"data" worksheet has rows for information as "Sales", "Revenue" or "Margin"
and columns for the months. Each month I want to move the links from the
"summary" sheet to the new month column in the "Data" worksheet - from July
to August etc. The new month is the next column to the right. How do I do
this without moving each link individually?
G
Gord Dibben
Andrew
See in-line
Your cuurent post is to the microsoft.public.excel.worksheet.functions area so
you found your way here somehow.
Post to any one of the Excel news groups and it will be read by all the
regulars.
The programming group mostly deals with VBA issues so may not be a group to post
to.
Not too clear here but assuming you have links in column A of summary sheet back
to Data sheet that look like =Data!A1 and so on down the column.
Select this range of links and copy over to column B.
They will now read =Data!B1 and so on down the column
Gord
See in-line
Thank you for that. I do not know how to get to the
microsoft.public.excel.worksheet.functions area but I am sure I'll find out.
This is all new to me.
Your cuurent post is to the microsoft.public.excel.worksheet.functions area so
you found your way here somehow.
If I should only do one posting for a problem how do I know where to place
it? It is not always obvious to me.
Post to any one of the Excel news groups and it will be read by all the
regulars.
The programming group mostly deals with VBA issues so may not be a group to post
to.
I have Excel 2003
My original question was:
I have a "summary" worksheet which takes data from a "data" worksheet. The
"data" worksheet has rows for information as "Sales", "Revenue" or "Margin"
and columns for the months. Each month I want to move the links from the
"summary" sheet to the new month column in the "Data" worksheet - from July
to August etc. The new month is the next column to the right. How do I do
this without moving each link individually?
Not too clear here but assuming you have links in column A of summary sheet back
to Data sheet that look like =Data!A1 and so on down the column.
Select this range of links and copy over to column B.
They will now read =Data!B1 and so on down the column
Gord