Posts by pmnfdo

Hi all,

I have a workbook with two sheets Data EnteringPage-plan & Data EnteringPage-Actual,

Same set of data’s are filled in Columns ABCD in both sheets,

I need to fill ‘Data EnteringPage-Actual sheet’ with same set of data ( From Col.A-D) when the user enters Data in ‘Data EnteringPage-plan’ .

I have tried grouping of sheets but I don’t know whether grouping can be applied to portion of a sheet?

I have tried copying the whole area of Col. A-D to the other sheet with pasting the link but that seem to be very in efficient and increases the file size tremendously. There may be a better way to do this.

Any ideas? I have attched my work book.

Thanks.

Re: Link Dynamic Named Range To Another Sheet

Thanks, May be i was not clear enough, i want to get the sheet2 updated whenever i put data in sheet1, that is i need identical datas in sheet1 and sheet2

I have a dynamic named range named ’db’ in sheet1. I need to have the same range linked to sheet2 starting in cell A1. Can anyone help pls?

Thanks

Re: Efficiently Deal With #N/A Error

Thanks, Is there anyway to populate the formula in column G depending on number of positions selected?

Re: Avoid Displaying N/a When matching Data Is Not Found

sorry for not attching the workbook earlier ,herewith i have attched the work book

In the attached work book I have 2 sheets named, Data Entering page-plan and Varaince Summary-in hours.

Data Entering page-plan - is used to enter data
Varaince Summary-in hours. – is used to retrieve data

In ‘Varaince Summary-in hours. ‘ sheet in Cell A6 I have a drop down to select the job nos , according to the job no selected date, position no, and milling hours are filtered and displayed.

I have written a index/match formula in G6 and have dragged it downwards since I don’t know how many positions would be fetched in each job no selected.

Is there any way not to display N/A in unused cells in Column G each time a job no is selected embedding the function in a IF using ISNA or ISERROR would be inefficient as I feel since this sheet is going to house lot of data of about 30 sections, I have shown only one section here)

Any suggestions would be greatly appreciated.

Re: Remove Unknown Characters & Display as Multi-Line Wrap Text

Thanks, when wrap text multiline is ok but the square chr still appears here and there

I have a exel file which has been exported from Access to exel. There are many cells which shows the data as in Cell A1 with the Linefeed character in between data in a cell.
Is there any way (may be using a macro) where I can remove the character and get it to display as B1 in the same cell(A1). The file is attached herewith.

Thanks in advance.

Re: Named Range To End At 1st False

Thanks, everybody I was able to solve my problem, Daves answer suits me well.

In the attached Exel work book I have a Column with entered datas up to row 15 in column B, also in column b, from row 15 downwards I have FALSE(result of a vlookup, returns false since the other relevant data is not entered)
I don’t know how to write the formula to get the dynamic range defined until FALSE appears.(highlighted range)

Any help would be greatly appreciated..