Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying data relevant to the position of a cell on another sheet
I have a sheet with 80 rows of data. The user selects a cell in the first column of the table of data. The macro then confirms the cell is within range and allows the row contents to be deleted. So far so good. Another sheet is then selected where i need to replace the data on a specific line with formulas that are hidden elsewhere on the sheet. My problem is, if the user selects say row 39, how do i select row 39 on the next sheet. Any help will be greatley appreciated Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying data relevant to the position of a cell on another sheet
if a user selects row 39 that is the row of the activecell.
myrow=activecell.row However it sounds like you could do away with most/all selections. post your code for comments. -- Don Guillett SalesAid Software "Darren Elsom" wrote in message ... I have a sheet with 80 rows of data. The user selects a cell in the first column of the table of data. The macro then confirms the cell is within range and allows the row contents to be deleted. So far so good. Another sheet is then selected where i need to replace the data on a specific line with formulas that are hidden elsewhere on the sheet. My problem is, if the user selects say row 39, how do i select row 39 on the next sheet. Any help will be greatley appreciated Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copying data from a cell on sheet to a diff cell/sheet | Excel Worksheet Functions | |||
Making a cell show relevant data | Excel Discussion (Misc queries) | |||
Sum of 3 nos. into 1 cell in another sheet relevant to specific da | Excel Discussion (Misc queries) | |||
Copying matched criteria plus relevant columns to new worksheet | Excel Discussion (Misc queries) | |||
Copying a sheet to a certain position | Excel Programming |