Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I link cells?
I have a report that gets updated monthly. Some info comes
in the report, the rest I have to put in. I take my original report and copy it to two worksheets within the workbook (Original, Changes, Inventory). On one sheet (Inventory), I can vlookup information from the previous month's report, and it fills it in. Vlookup doesn't work on the other sheet (Changes), even though there are no formatting differences, using same report from previous month. Col a = company number col's b-h need to be filled in identically to all other months based on the company number (column mapping is the same). Is there an IF function that would do this ? Or why will vlookup work on the other sheet & not this one? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link All cells of Sheet1 to All Cells of Sheet2 | Links and Linking in Excel | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions |